Alison Balter's Mastering Access 2002 Enterprise Development

Using Pass-Through Queries

Ordinarily when you store and execute a query in Access, even if it is running on remote data, Access compiles and optimizes the query. In many cases, this is exactly what you want. On other occasions, however, it might be preferable for you to execute a pass-through query because these queries are not analyzed by Access's Jet Engine. These queries are passed directly to the server, and this reduces the time that Jet needs to analyze the query and enables you to pass server-specific syntax to the back end. Furthermore, pass-through queries can log informational messages returned by the server. Finally, bulk update, delete, and append queries are faster using pass-through queries than they are using Access action queries ...