Access - creates duplicate file

[Guest]

With a database stored on a network drive, Access 2007 creates a copy each
time I close it, and names it database, database1, database2, etc. This does
not happen when I have the database stored on my hard drive. How can I stop
this from happening?

 

[Guest]

Make sure you have the appropriate rights on the networkdrive. Read/Write.
That should do the trick.

 

[John W. Vinson]

With a database stored on a network drive, Access 2007 creates a copy each
time I close it, and names it database, database1, database2, etc. This does
not happen when I have the database stored on my hard drive. How can I stop
this from happening?

My guess is that you have Compact on Close set; when Access compacts a
database it makes a copy (usually named db1), copies the existing database
into it, deletes the old database and renames db1. It sounds like this process
is getting blocked. So... Turn off Compact on CLose for one thing...!

And then check the user's permissions to that network folder. It's simplest to
give the user full Read, Write, Create and Delete (but not Administer)
privileges to the folder. Access creates a .ldb locking file when the first
user opens a database (frontend or backend), and deletes it when the last user
exits.


John W. Vinson [MVP]

 

[Guest]

Thank you so much for your help - it was the "compact on close" setting. Once
I changed it, the problem went away.