Pass through queries

  • Thread starter Thread starter Ling
  • Start date Start date
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
 
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>
 
Back
Top