ODBC--call failure after trying to run union query.

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

Guest

I have a union query, that unites 3 separate queries. Each query works fine,
and as soon as I run the union query, sometimes I receive results, sometime I
receive the "ODBC--call failure" message.
please help
 
Try setting the ODBC Time-out Proerty of the Query to a longer period than
the default 60 secs.
 
All I see in Access is ODBC refresh interval (sec) and that is set to 1500
nothing was set to 60?
 
Not the general Refresh Interval in the Menu Tools / Options ...

Open the Design/SQL View of the Query and open the Properties window for the
Query and ODBC Time-out is one of the Properties listed. This is usually
defaulted to 60 secs.
 
OK, did see 60 there, so I changed it to 1500, but still received the ODBC
Call failure.
funny thing is that it does seem to work for some searches, and not for others
 
You Union Query may be trying to pull down too much data. It may be more
efficient to use Pass-Through Query.

Check Access Help on the Pass-Through Query.
 
Back
Top