MySQL Forums
Forum List  »  Microsoft Access

Re: Updating MySQL table through Access creates Locking violations Error
Posted by: Jonathan Shaltz
Date: September 28, 2005 01:44PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Updating MySQL table through Access creates Locking violations Error
3357
September 28, 2005 01:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.