I was working on an old application today and I have encounter an error "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time". The application uses a Microsoft Access database to store all its data in it and the size of the database is around 60 MB. Looking at the error message you would have think that issues has something to do with record locking. I copied the database to another computer and then I try to open it, then perform a select query and again I am getting that error.

As I am determining to find out what causes the error, I scroll through thousand of records from one of the table and noticed that one of the field has got the word "#Error". Now that really is interesting isn't it. I click on that field and the error pops up saying "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time".

SOLUTIONS:

I have come to a conclusion that may the Access database has been corrupted so I have recorded all the values of the corrupted record. Then I deleted the corrupted record, re-created the new record and populating the old data back in. To locate the problem record try to search for recard that has the word "#Error" in it.

Also first try to compact and repair the database and see if that fix the issue. To repair and compact the database click on Tools -> Database Utilities -> Compact and Repair Database ...

• Add New
• Search

Comments (1)

• |27.33.185.xxx |2012-01-25 09:37:53 Anonymous
  thanks for the info.

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Website:

Comment:

Title:

Message:

Security

Please input the anti-spam code that you can read in the image.

"