Timeout on querying a link table

L

Lianne Kwock

Hello,

I was trying to run a query on a link table, which resigns on SQL Server. I
got a timeout message, but I have no problem running the same query on SQL
Analyzer.

Any input on this is highly appreciate.


Thanks,
Lianne
 
D

Duane Hookom

Have you tried creating a pass-through query?
Maybe you could share your sql view?
 
V

Van T. Dinh

There is a big difference running the Query / SQL in Access and in SQL
Analyser.

When you use the SQL Analyser, the SQL Server does the processing and only
return the selected rows to your desktop, i.e. less network traffic. When
you run the Query through Access interface (and this depends on how you set
the PK, indices), the desktop processes your request which sometimes means
that there is more data needs to be transferred to your desktop, i.e. more
network traffic.

If possible, use Pass-Through Query rather than normal Select Query.
 
Top