Default field type in ODBC passthru query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am utilizing a passthru query with an ODBC connection.
I then use a make query from the passthru.
Usually this works fine but once in a long while I get a type mismatch
because the resulting table ends up with several field types as text instead
of number (ODBC connection source table is number). Problem does not appear
to be related to the Access default field type setting. Know any other
method to maintain (or force) field type other than using an delete/append
query combination instead of the make query? Or why this happens?
 
I am utilizing a passthru query with an ODBC connection.
I then use a make query from the passthru.
Usually this works fine but once in a long while I get a type mismatch
because the resulting table ends up with several field types as text instead
of number (ODBC connection source table is number). Problem does not appear
to be related to the Access default field type setting. Know any other
method to maintain (or force) field type other than using an delete/append
query combination instead of the make query? Or why this happens?
Click to expand...

MakeTable queries are known for this problem. Access is guessing at
the field types based on the data in the table, which of course can
change. It is much more reliable to do as you suggest.

Use a combination of delete and append queries on a table that is
structured exactly the way you need it.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top