Program creates dupicate databases

  • Thread starter Thread starter Cvandy
  • Start date Start date
C

Cvandy

Using MS Office XP Professional
When I close a database after entering data, Access
automatically creates a new file with a 1 at the end.
Each time I open the database, another file is created
with another 1 at the end (i.e., test1, test11, test111).
In this example, if I opened test 1, it would not be the
most current database. How do I keep the same file
current upon exiting the program rather than creating
duplicates?
 
My guess is that you use the "Compact-On-Close" option.

When you compact a database, Access actually compacts your database into a
new temporary mdb file (usually named "dbX.mdb", not sure in your case).
Upon completion of the compaction, Access deletes the existing file and
rename the temporary mdb file to the existing name.

It sounds like Access does the compacting but some how doesn't manage to
delete the old uncompacted file and rename the temporary file.
Check the file size of exiting file and the temporary file (smaller).

It is possible that some minor corruptions create this. Try create a *new
blank* database and import all objects from the existing database and see if
the problem goes away.
 
Back
Top