Question about pass through queries

I have a large database where I am contemplating using pass-through
queries to all my ODBC tables or just bringing in all the linked
tables and running queries from the tables. What I am most concerned
with is which method will have better performance? Will it make a
difference?

Thanks!

Performance should be much improved with P-T queries. Keep in mind, your P-T
records will not be updateable and the SQL must match your database server
syntax. You also can't join to a local table within the P-T.

--
Duane Hookom
Microsoft Access MVP


"Bongard" wrote:

I have a large database where I am contemplating using pass-through
queries to all my ODBC tables or just bringing in all the linked
tables and running queries from the tables. What I am most concerned
with is which method will have better performance? Will it make a
difference?

Thanks!

Thanks much Duane! The reason I asked is because it felt like a few of
my basic pass-through queries were running slower than the queries
based off the linked tables and I didn't know whether I should go back
to linked tables or not.

Thanks for your help!

It's always been my experience that P-T queries are more efficient. It might
be an issue where you have a criteria in the linked table query and no
filtering on the P-T.
--
Duane Hookom
Microsoft Access MVP


"Bongard" wrote:

Thanks much Duane! The reason I asked is because it felt like a few of
my basic pass-through queries were running slower than the queries
based off the linked tables and I didn't know whether I should go back
to linked tables or not.

Thanks for your help!