Duplicate Access 2007 Databases

C

cfkniess

I have a database stored on a shared drive. Every time someone opens the
database a duplicate copy named "Database" is created. What causes this and
how can I stop it? I didn't have this issue with previous versions.
 
J

Jerry Whittle

What size it this duplicate database? If it's small, like 1 k, it's probably
the locking file. It should have a suffix of .ldb or something similar. If
that's it, don't worry; be happy.

If it's a full-sized database file with a .mdb or .accdb suffix, something
is strange. You may have compact on close enabled and it's being shut off
before the compacting happens. Or someone wrote some backup routine for the
database on open.

One thing to check is that all the database users have read, write, create,
and delete permissions on the folder holding the database file on the shared
drive.
 
Top