Here's an interesting problem: We have a Web application that we use to keep track of our company's assets; equipment and so forth. We recently moved the whole application from Windows Server 2003 to 2008, and added some entries. When we do a search or update from the Web application, all of the records are showing up normally. But when we open the .mdb file in Access, there are records missing, and the most recent update goes back to before we moved the database to the new server. We searched the hard drive, and there are no other .mdb files on the entire system. So the question is, where is the Web application storing the new data? Or, why are new records or updates not showing up in the .mdb file when they appear to be updated correctly in the Web app? I appreciate your help. I'm kinda new to Access, and databases in general.

When is the last time you did a Compact and Repair? It could simply be a bad index.

Thanks for your reply. I've passed your advice on to our network annalist, who's sort-of in charge of the thing, but he hasn't had a chance to work on it yet. I did poke around in the Data Source Administrator, to see if he'd configured a different database file, and I'm not entirely sure it's pointing to the right file. But if it's pointing at the wrong file, then that file has the same problem. It's confusing, but until those above me decide that it's important enough to put some effort into, I'm sort of at a standstill.

Thanks for the update.