By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,934 Members | 1,441 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,934 IT Pros & Developers. It's quick & easy.

Unwanted copy of Access database created upon close

P: 22
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?

Feb 25 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,532
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)>
Feb 25 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.