MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Updating MySQL table through Access creates Locking violations Error
7054
Craig Gall
August 30, 2005 05:56AM
Re: Updating MySQL table through Access creates Locking violations Error
3422
Jonathan Shaltz
September 28, 2005 01:44PM
Re: Updating MySQL table through Access creates Locking violations Error
3384
Sebastien Caisse
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.