Pass through queries

L

Ling

I have read on pass through queries and found out they
pass the queries directly to the database server for
processing.
Would the VBA code if affected if the ordinary queries are
converted to such pass through queries? For e.g., Dlookup
functions, would they be affected as well?

Thanx for any help

Ling
 
J

Jeff Boyce

Ling

Passthrough queries can only pass through SQL commands that can run on the
back-end db server. If that server can process DLookup(), you can pass it.
(I suspect not).

Good luck

Jeff Boyce
<Access MVP>
 
Top