MySQL Forums
Forum List  »  Microsoft Access

Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
Posted by: Clive Bradley
Date: April 26, 2005 04:26AM

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
Remote: Apache/1.3.27 (Unix) (Red-Hat/Linux) MySQL 3.23.58

Options: ReplyQuote

Written By
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
April 26, 2005 04:26AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.