Duplicate Access 2007 Databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top