MS Access / MySQL: unlock locked Records I have a Microsoft Access database that is connected to a MySQL server via ODBC and is accessed by multiple users. 

Over time many records are locked and editing is not possible anymore.

Is there a way to bulk unlock all records?

The Error Message:


  This record has been changed by another user since you started editing
  it. If you save the record, you will overwrite the changes the other
  user made. Copying the changed to the clipboard will let you look at
  the values the other user entered, and then paste your changes back in
  if you decide to make changes.
I finally could fix my problem by adding a field named TIMESTAMP of type timestamp and default value CURRENT_TIMESTAMP and attribute = on update CURRENT_TIMESTAMP.
Then i updated all records and set TIMESTAMP=NOW().

For now i did not get any error again.