MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

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?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
9207
Andy Home
April 07, 2005 03:29AM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3646
Jeroen Slemmer
April 10, 2005 06:26AM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3576
George Loeppky
April 11, 2005 09:51AM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3293
t2
April 20, 2005 03:27PM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
5814
Clive Bradley
April 26, 2005 04:26AM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3905
Stan VA
April 26, 2005 03:43PM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3595
jan.jessen
April 27, 2005 02:13AM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3228
Mark Schiavone
April 29, 2005 02:09PM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3088
George Loeppky
April 29, 2005 04:02PM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3165
Ed Hall
May 01, 2005 08:13AM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3480
Ed Hall
May 01, 2005 09:28PM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
2818
Carlos Ochoa R.
June 16, 2005 04:15PM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3192
Edward Finlayson
May 12, 2005 08:17AM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
2816
ruth conde
May 20, 2005 09:28AM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3553
Rein van der Mast
May 24, 2005 07:55AM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
2815
dhs
May 27, 2005 11:36AM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
2732
Dan Guzman
June 14, 2005 03:16PM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3324
Rein van der Mast
May 19, 2005 04:13AM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
2926
joe byers
July 05, 2005 01:15PM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
3586
Mike Baldam
August 05, 2005 11:15AM
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
4255
Calle Scharffenorth
August 19, 2005 05:43AM


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.