Access 2003 duplicating issue

[PMBO]

Each time I close a .MDB, Access 2003 makes a copy of the file in the form of
"db#.mdb", where # is a sequential digit starting with 1. Any idea what’s
going on?

 

[Jerry Whittle]

Yes. You have Compact on Close enabled in the Tools, Options, General tab.
Remove the checkmark there. You might want to also remove the checkmarks on
Track name AutoCorrect info while on that tab.

There's possibly another problem in that you may not have all the needed
privileges for the folder holding the database file. At the least you are
probably missing delete and should have it.