Re: Record Locking on Linked MySQL Tables

[Ronald Weng]

Hi I'm experiencing the same issue, while using the form in MS Access 2000 I keep getting that error with drop data due to some user locking the table...

Howevery while playing around with the forms I found a few interesting facts.

1. In a subform (lets call it Truck) within a form (Car), if any updates are changed in the Truck form, the timestamp field doesn't update in Car form which leads to the message "The record has been changed by another user since you started editing it." It gives the option of "Copy to Clipboard" or "Drop Changes"

2. However my timestamp field in Truck seems to update

3. The timestamp field in Car doesn't update as no changes are made

Could it be that both timestamp field must be updated before the error will fall away.

Does anyone have a solution?

I'm using Mdac 2.8 as well as Windows XP SP2, MySQL 4.1.9, ODBC connector 3.51.11-2. Yet no solution... I guess the users will have to work with a stupid popup message if I can't find a solution :(