Compacting a database

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

Guest

Hi

I have been trying to compact my database but it keeps coming up with an
error message "the microsoft jet database engine stopped the process because
you and another user are attempting to change the same data at the same time".

There is no-one else using the database currently.

Please could you help?

Thanks

Carolxx
 
Close the database and make sure everyone else has it closed also. Go to the
folder that the file is in and see if there is an *.ldb file with the same
first part of the name as the name of your database file. If so and no one
has the database open, delete the *.ldb file and try again. This file is the
"lock" file and is supposed to be deleted when the last user closes the
database, but it will sometimes get left, especially if one of the computers
didn't properly close Access.
 
Back
Top