---

MS Access 2003: Pass-through Introduction

This MSAccess tutorial explains the purpose of a pass-through query in Access 2003 (with screenshots and step-by-step instructions).

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.