Getting Access working with MySQL

[john.hearn]

I have got access 2003 working along side MySQL and need to keep two databases in step, one in MySQL and one in Access.

I can link from Access to the relevant tables in MySQL but get some odd results:

If I write an update query in Access then it will work and update the MySQL table.

If I try to update the same row by opening the table within Access, I get an error : ODBC--upadate on linked table'pet'failed. [Microsoft][ODBC Driver Manager] SQL data type out of range(#0)

If I write a simple DAO program to update the same table I get : ODBC--update on linked table 'pet' failed.

If I copy in the code in section 23.1.19.2 of the manual and run it, I get the error: Cannot update. database or object is read-only

Any suggestions will be gratefully received :-)