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

[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

 

[Van T. Dinh]

Try setting the ODBC Time-out Proerty of the Query to a longer period than
the default 60 secs.

 

[Guest]

All I see in Access is ODBC refresh interval (sec) and that is set to 1500
nothing was set to 60?

 

[Van T. Dinh]

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.

 

[Guest]

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

 

[Van T. Dinh]

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.