MySQL tables

[Guest]

Hi all,
I have an Access form that I am trying to integrate with a MySQL back end,
however, I am getting all sorts of run time errors and ODBC errors when
trying to update and insert new records. When originally testing with MS
Access tables, all worked well, but once I converted the tables to MySQL, I
am having problems (runtime error 3155). Not sure if I am in the right
place, but any information would be greatly appreciated!
thanks!
-gary

 

[Guest]

I found the answer to this - it is because of the conversion of the Access
tables to MySQL which was causing the majority of the errors.
First, make sure all your tables that are going to be updated have a primary
key assigned in MySQL
Second, wherever you had a Yes/No field in Access, it will convert over as a
TINYINT no null allowed field in MySQL - this causes severe problems and will
not allow for any table linkage to occur - convert all TINYINT fields to
BOOLEAN and make sure that a null value can be accepted.
Hope this helps others as well!
-gary