How do I stop Access from duplicating the database?

[Guest]

Everytime I close my Access database, it duplicates itself. What do I do to
stop the database from creating copies of itself?

 

[Immanuel Sibero]

Hi JS,

Tools>>Options>>General
Is *Compact on Close* selected? Maybe?


Immanuel Sibero

 

[John Vinson]

Everytime I close my Access database, it duplicates itself. What do I do to
stop the database from creating copies of itself?

Do you get a new database named db1.mdb, db2.mdb and so on?

If so, the likely cause is that in Tools... Options you have set the
database to "Compact On Close"; and the folder in which the database
resides is protected so that you cannot delete files. You need FULL
read, write, create, and delete permissions on the folder, since
Access needs to create a new database, compact your existing data into
it, and then delete the old one; or, you need to turn off Compact on
Close.

John W. Vinson[MVP]