我有一个Microsoft Access数据库通过ODBC连接到MySQL服务器,并由多个用户访问.

随着时间的推移,许多记录被锁定,不再可能进行编辑.

有没有办法批量解锁所有记录？

错误消息：

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.

解决方法:

我终于可以通过添加一个名为TIMESTAMP的字段来修复我的问题,该字段的类型为timestamp,默认值为CURRENT_TIMESTAMP,而attribute = on更新CURRENT_TIMESTAMP.
然后我更新了所有记录并设置了TIMESTAMP = NOW().

现在我没有再收到任何错误.