Re: Updating MySQL table through Access creates Locking violations Error

[Jonathan Shaltz]

Good afternoon, Mr. Gall.
I may have something similar. On just one of 50 or so MySQL tables I've linked into Access, there is one I cannot edit. I get a message along the lines of "this record has been changed by another user, do you want to drop your changes?" My best guess on the cause is that Access isn't reading the primary key correctly. My table uses a CHAR(5) NOT NULL and a CHAR(6) NOT NULL together as the primary key; MySQL has no problem with this, but I think Access does.
I suggest you add a simple primary key to a table, and see if that fixes things. And please let me know if it works for you!
Any experienced Access-MySQL peeps out there, please chime in if I'm on the right track with this - or if I'm not!
Thank you.