MS Access Tutorial: Pass-through Queries in Access 2003/XP/2000/97 (page 1 of 12)
What is a Pass-through Query?
A Pass-through query allows you to execute a SQL statement directly against the tables in an external database (such as an Oracle, Sybase, or SQL Server database). This method uses your ODBC connection to directly access the data in the external database without having to link to the tables or import the data from the external database.
This tutorial will demonstrate how to create pass-through queries as well as how to integrate pass-through queries with other queries in your Access database.