linked tables vs. pass-through queries

H

Huh?

Would performance be better if I queried a linked table or if I used a
pass-through query? and why? or would it matter at all?
 
R

Rick Brandt

Huh? said:
Would performance be better if I queried a linked table or if I used a
pass-through query? and why? or would it matter at all?
Click to expand...

If you don't need to make edits and don't need to use it as the input to
local queries then a Passthrough might be faster. If you need either of
those two then use a link.

Also, Passthroughs can't be used in subforms or subreports.
 
Top