MySQL Forums
Forum List  »  Microsoft Access

Re: Updating MySQL table through Access creates Locking violations Error
Posted by: Sebastien Caisse
Date: September 30, 2005 06:24PM

I just made a table with CHAR(5) and CHAR(6) both being the primary key and exposed it as a linked table through myODBC and had no trouble with it.

Access does support primary keys on several CHAR (Well, "Text" is it calls it) type and I've tested it through a simple form and it still does support it through ODBC (and more precisly through the myODBC driver).

Might I suggest turnning on query logging on a test copy of the db to see what access is doing exactly, unfortenetaly it is quite secertive about it's inner workings unless you snoop around.



Edited 1 time(s). Last edit at 09/30/2005 06:25PM by Sebastien Caisse.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Updating MySQL table through Access creates Locking violations Error
3326
September 30, 2005 06:24PM


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.