Hello
I need to read and write a table contained in an MDB. I have gone the ODBC way, I can connect and read records via sqlexec() with no trouble. However, if I try to insert a record with:

res = sqlexec(myconn, "insert into mytable (field1,field2) values (1,2)")

it returns -1.
The error message is
"1526 Connectivity error.... [ODBC Microsoft Access Driver] Numeric value out of range (null)
I tried listing all fields of the target table, same result. There are no nulls around..
Any ideas?
VFP7 SP1 on Win XP

Thanks!