Copy of database

  • Thread starter Thread starter work
  • Start date Start date
W

work

I have an access database in a multi-user environment that sometimes dumps a
copy (db1.mdb) into the folder where the original is saved.

Does anyone know what causes this and how do I prevent it from happening.

Thanks
Jo
 
Someone is using compact and repair without everyone
having the program closed. Only one user can have the
database open when you do a compact and repair.

Hope this helps.

Reed
 
You don't say what OS the database is in but you should be able to look and
see who the owner/creator of the file is under properties. db1.mdb is the
default name access uses for a new datafile or it increments the number if
that name is already in use. Someone may be doing it by accident when the
are in access, running a wizard, creating a new blank datafile or compacting
one they are in while someone else has orginal open.
 
Back
Top