Compacting a database

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
 
W

Wayne Morgan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database becomes inaccessible 1
Access error 3197 and JETCOMP.exe error "Error compacting database 2
Access Jet Database Engine Stopped 2
Database Become Inaccessible 2
database wont open 7
Can't split a database 2
Access 2000 Jet error problem 1
Unable to open Access 2003 database 1

Top