Re: Record Locking on Linked MySQL Tables
I had the same problem. It turned out to be a datatype mismatch in the tables. I was using unsigned integers to store true/false data but Access default true is -1 not 1 so it gave me a record lock error. Once I changed the field to signed integer the problem went away.
Edited 1 time(s). Last edit at 10/17/2005 09:16AM by Christopher Mueller.
Subject
Views
Written By
Posted
5513
May 18, 2005 01:34PM
2353
May 18, 2005 02:29PM
3038
August 30, 2005 07:25AM
2389
September 22, 2005 09:46AM
2696
October 10, 2005 06:25AM
Re: Record Locking on Linked MySQL Tables
2345
October 17, 2005 09:15AM
2328
December 04, 2005 11:17AM
2192
December 05, 2005 07:47AM
2171
January 05, 2006 04:13AM
2780
February 02, 2006 11:12AM
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.