MySQL Forums
Forum List  »  Microsoft Access

Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
Posted by: Ed Hall
Date: May 01, 2005 08:13AM

I'm moving over an app that is yes/no and date intensive. I used the migration tool kit which seems to have converted all the tables properly. The check box yes/no are tinyint(1) and the timedate are still datetime.

My problem is the ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out range error.

I converted a timedate to VARCHAR(20) and the formatting on the access form to =(mm-dd-yyyy) with no success.

Additionally, the form text box gets it's data from a calendar control. Can't change that much.

Any Ideas?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
2928
May 01, 2005 08:13AM


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.