Linking SQL tables in Access XP

[Brian]

I have an access database that has several links to sql
tables. I have a query that uses about 7 sql tables
joined to get a result set. The problem is that with so
many links the query is sooo slow because it constantly
has to go back to sql. Beside creating make tables using
the sql links than using those tables in the query to get
my result set, I can't find another way to speed up the
query. Does anyone have any advice?

 

[Joe Fallon]

Sure.
Send the whole query to SQL Server as a SPT (SQL Pass Through).
(In design view of the query go to the menu and choose:
Query
SQL Specific
Pass Through)

Then it will run blazing fast.

1. You need to use SQL Server dialect, not JET.
They are similar but not identical. Replace * with %, etc.

2. The result set is read only.

 

[Timothy Ford MCSD MCP]

Use a pass-through query so it processes on the SQL
Server. Don't use local Access queries.