MySQL Forums
Forum List  »  Microsoft Access

Re: Record Locking on Linked MySQL Tables
Posted by: Manavi Sharma
Date: February 02, 2006 11:12AM

Hi...

Thanks a lot!
Even i was facing a similiar problem n it helped me solve it.

Important information for developers using SQL Server 2000, MSAccess linked tables is.
There is datatype Yes/No in SQL Server 2000, that is of type 'bit'... MSAccess doesn't recognize it.. n so any interface(form) in MSAccess wont allow the change.
In such a case, change the datatype 'bit' in SQL Server 2000 to 'int'... and again link the tables.
Your problem will be solved.

Regards,
Manavi

Options: ReplyQuote


Subject
Views
Written By
Posted
2321
December 04, 2005 11:17AM
Re: Record Locking on Linked MySQL Tables
2772
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.