Extra db1.mdb files

[Michael]

Hi Folks - Not sure this is the right forum ... After a week of database
activity, we are seeing a lot of db1.mdb files in the database directory. We
think it is related to compact on close, but we are not sure. Is there any
other way that stray db1.mdb files would be created? Note: We run a macro
that imports data via an ODBC connection. Thanks.

Michael

 

[Nikos Yannacopoulos]

Michael,

Chances are it is the Compact on Close... the way compact and repair
works in Access is, it closes the original database, saves the
compacted/repaired .mdb in db1.mdb (or 2, 3 etc... next available), then
deletes the original and renames db1.mdb to the original name. If
the compact and repair is run manually it then re-opens the database, if
it is a compact on close it doesn't.
Now, sometimes the original .mdb cannot be deleted for some reason, so
the process ends there and you are left with the original (uncompacted)
database and a db1.mdb, which seems to be your case. The most common
reason for this to happen is that the original database does not close
properly, and the lock file isn't deleted, so the original database
can't be deleted.
This is easy to verify by doing a manual compact and repair while in the
original, and see if you get the same behaviour. Another thing to check
to verify this theory is the date/time of the db1.mdb, which should be
the time the original was closed.

HTH,
Nikos