Why is a db#.mdb created each time I close my database?

[uptake24875]

Every time I close my access database, a "backup"version of my database is
automatically created with a sequential suffix (e.g. db1, db2, db3...). Why
is this, how do I change this setting.

 

[tina]

well, if you have the Compact on Close option turned on, and the database is
unable to compact successfully for some reason, i suppose that might result
in the files you're seeing created. to check it out: open the database to
the database window. on the menu, click Tools | Options | General tab and
look for a checkmark in the Compact on Close box about halfway down the left
side of the dialog box. if it's checkmarked, remove the checkmark, click
Apply and then OK. then try to compact the database by clicking Tools |
Database Utilities | Compact and Repair. see if you get an error message, or
a message of any sort, at some point before or during the compact.

hth

 

[John Spencer]

Another option is that you don't have delete privileges on the folder where
the database resides. That is really easy to check. Try deleting one of the
multiple copies - if you can then you do have delete privileges. If you
can't then you or your IT department (if you have one) must set up privileges
on the folder that allow you to delete items in the folder.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[uptake24875]

I checked the delete privileges and I can delete files in that folder. I
also checked the compact on close feature and that was checked, but when I
ran through the process of manually repairing/compacting, I didn't get any
errors.

Any other ideas?

thanks in advance!
-Bryan

 

[tina]

no, i've emptied my bag of WAGs. hopefully somebody else will have an idea.
good luck with it!