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

[Clive Bradley]

I am having a very similar problem.
I have a pair of tables on a remote MySQL Server and a Local Access Form
(Orders / OrderItems)
With My form/sub-form I can create new records in the parent table Order and the child table OrderItems, but if I then try to edit a record (in either) I get the error message.

ODBC - insert on a linked table <TableName> failed
[microsoft][ODBC Driver Manager] SQL data type out of range(#0)


In my case I am now sure that it is to do with the TimeStamp field which Access "sees" as a Text Field. It gets the Create Date OK, but cannot be updated.

I have tried changing the TimeStamp to Text and have Access set it to =CStr(Now()),
but it only sets the initial "create" date/time and it does not update on subsequent edits :(

Can't seem to crack this at all ...


Techie Stuff :
Local: Windows 2000 / ODBC is 3.51.11.00
Remote: Apache/1.3.27 (Unix) (Red-Hat/Linux) MySQL 3.23.58