I get a copy of the database called db1 when I close my database

[James New]

Everytime I open and close the database the record lock transforms into a
copy of the database called db1, if I do this 5 times then there are 5
separate db's created such as db2, db3 ect...

How I can change this so that a copy is not created?

Thanks,

James

 

[Arvin Meyer [MVP]]

You may have your database set to compact on close and have a problem with
it or with permissions on some objects. When Access cannot properly finish
compacting, or if permissions to rename are not allowed, you will be left
with a file named db1, db2, db ...

 

[John W. Vinson]

Everytime I open and close the database the record lock transforms into a
copy of the database called db1, if I do this 5 times then there are 5
separate db's created such as db2, db3 ect...

How I can change this so that a copy is not created?

Turn off "Compact on Close" in the database properties, for one thing. What's
happening is that Access is trying to compact the database; this is done by
copying the database to a new database named db1.mdb (or db2 if there is one,
etc.) The current database is then deleted and the newly created one renamed
to the old name. If you don't have permissions to delete or rename files in
the folder where the database resides this will fail and leave the copy
sitting around.

 

[a a r o n . k e m p f]

it sounds to me like the compact / repair functionality is too much
effort for you.

I'd upsize to SQL Server and use ADP and you don't need to worry about
this any longer

 

[Arvin Meyer [MVP]]

Sorry, but you're wrong again. You have to periodically compact an ADP as
well.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


message
it sounds to me like the compact / repair functionality is too much
effort for you.

I'd upsize to SQL Server and use ADP and you don't need to worry about
this any longer