I have an Access 2007 database, containing 1 table and some code, which processes a series of .csv files contained in a folder and inserts their data into this 1 table.

I have set the database to compact on close. Other than this, I have set no other database options.

For some reason, whenever I close the database, another database by the name of 'Database' is spawned in the same location and of similar size. If I subsequently open the database and close it, it spawns another database 'Database1' and so on.

What and why are these additional databases being created?

Any help would be much appreciated!

Thanks, Keith

Bit of extra information: If I un-check the compact on close option, no additional databases are created when I close the main database.

Also a bit of information on these 'cloned' databases: I notice their file type is 'Microsoft Office Access Database', as opposed to the main database, which is 'Microsoft Office Access 2007 Database'. Also, if I open any of these spawned databases, they are identical in content, including VBA code, to the original.

I have created other databases in the past, which compact on close and don't do this, so why is this happening now?

After trawling through the internet, I found someone with the same problem. It seems as though the locking file Access generates when a database is open can sometimes not close quickly enough when the database itself is closed and compacts. Therefore, another database is generated. This could be a side effect of having the database on a network drive, which both myself and this other person have.

Seems a bit of a daft oversight for such an established piece of software. Can anyone confirm this or why it happens?

I have noticed that same thing, even though I am using 2003. On my desktop, there is no problem, but on the network, the same issue. I haven't asked the IT dept., however, I think that Access may not have Delete rights on the network.

Whenever you compact on close, Access creates a new database and all of your objects are copied to it. It then deletes your original copy and renames the new db with your old db's name. If it can't delete the old it just leaves both.

You can watch this happen if your db takes long enough to compact. As it is compacting, go to the folder where your database resides, and you will see it in progress.


Allan