ODBC call fails.

  • Thread starter Thread starter SHIPP
  • Start date Start date
S

SHIPP

I have a query that when run fails (ODBC call failed).
However, when I run a report with the query as the control
source the report is successful and shows me the correct
data. Any ideas would be appreciated.
 
Hi!!!

The ODBC Access driver is a little bit limited. You
cannot do all the things that you can do from within
Access. This specially applies if you have a custom
function (or a not-so-common function) in your query.

Try to split your call into simpler calls, avoiding
custom functions.
 
I do not have any custom calls. I am simply bringing down
6 fields. In addition why would the report work, which is
based on the query, and when the query is run by itself I
receive the error message ODBC call failed.
 
Back
Top