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)>
22
