I've got several Access 2000 databases that are currently being run
with Access 2007.
When the databases close, I've got them set to compact on close. This
creates the database1.mdb file, however once the database has finished
compacting and the database is closed, the database1.mdb still remains
in the folder. As a result, the next time the database closes, it
creates a database2, which it does not delete, and this continues each
time the database is closed.
This appears to ponly be happening on the databases that I have up on
my company's network, but does not happen on the databases I have on
my local C:\ drive.
Does anyone know why this would happen, and how to fix it?