ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out

[Andy Home]

i have installed Easyphp 1.8 on my PC and set up a mysql database on it...it works perfectly,

i have also installed MYODBC and again i have linked this up to the tables in MYSQL - Perfectly

I have created a form for data entry in MS Access 2000 and all is linked up ok, showing current recordsstored in the mysql table

PROBLEM!!!

the problem is that when i try to add records the form i get the following message:

ODBC - insert on a linked field 'plmatchdata' failed
[microsoft][ODBC Driver Manager] SQL data type out of range(#0)

can anyone offer some advice please

cheers

Andy