Unwanted copy of Access database created upon close

[kickergirl]

I created a database in MS Access 2000 that is being used by another person using Access 2003. Everytime they open the database and close it, a "db1" copy of the database is created. This does not happen when I open the database on my network. Has anyone ever heard of this phenomenon and/or know of a solution?

Thanks!

[missinglinq]

I believe Access creates a new database (db1 or db + the next available number) when it does a Compact and Repair. It then, I believe, deletes the original db, copies the new db as the original db (gives it the original's name) and then is supposed to delete the db1. Sometimes, for reasons I've never seen posted anywhere, it fails to delete the db1.

I'm guessing this happens because you have the Compact on Close option set, and if this is correct, you need to turn it off! Compacting can corrupt a database, and should only be done after the database has been backed up, so you should be doing this manually, when needed. There's really no valid reason for doing a
C & R each time a database is closed.

Linq ;0)>