ODBC Query Problem

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I link my database to some AS400 based tables. Recently,
some queries have failed to run with the message "ODBC
call failed". However, I can open and view the tables
through Access.

Any ideas why I can view the tables, but not run a simple
select query on them?
 
Are you using Select * ?

Try Select Field1, Field2, etc.

But do it one field at a time until you get the failure so you can identify
it.
Probably has an incompatible data type.
 
Back
Top