Timeout on querying a link table

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

Guest

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
 
Have you tried creating a pass-through query?
Maybe you could share your sql view?
 
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.
 
Back
Top