linked tables vs. pass-through queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Huh? - 15 Sep 2005 17:54 GMT

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?

Reply to this Message

Rick Brandt - 15 Sep 2005 18:07 GMT

> 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?

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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message