ODBC call fails.

[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.

 

[Manuel]

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.

 

[SHIPP]

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.