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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass Through Query - not returning rows 1
Question on Pass-through Query 4
pass through query variables 8
Like "* " and function to pass parameters into a query 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Displaying pass through query 1
Using pass-through query results in forms 0
pass through query for sub report 0

Top