R
Rusty
Thanks. I understand the principles of the passthrough queries, I don't
quite understand the actually mechanical use of them. The description of the
query above is this. The query in question is a Make Table query. It
contains 11 tables 4 querys that are joined in various ways, all indexed
properly. 4 of the tables are from MSSQL 2000 (linked). Now I can see why I
would get a big hit on performance due to the sheer complexity, but that
still doesn't answer why this exact query runs better on a slower, Access
97/MSSQL 2000 machine than it does on the Turbo Xeno, Access 2000/MSSQL 2000
machine. I can live with the 4 mins. I can't live with the 4 days. (lol)
Rusty
quite understand the actually mechanical use of them. The description of the
query above is this. The query in question is a Make Table query. It
contains 11 tables 4 querys that are joined in various ways, all indexed
properly. 4 of the tables are from MSSQL 2000 (linked). Now I can see why I
would get a big hit on performance due to the sheer complexity, but that
still doesn't answer why this exact query runs better on a slower, Access
97/MSSQL 2000 machine than it does on the Turbo Xeno, Access 2000/MSSQL 2000
machine. I can live with the 4 mins. I can't live with the 4 days. (lol)
Rusty