totn Access 2003 Pass-through Queries

MS Access 2003: Link Query to ODBC

This MSAccess tutorial explains how to link a pass-through query to an ODBC connection in Access 2003 (with screenshots and step-by-step instructions).

Link the Query to the ODBC connection

Now, it's time to link the query to the ODBC connection that you configured at the beginning of this tutorial.

To do this, under the View menu, select Properties.

Microsoft Access

When the Query Properties window appears, click on the property called "ODBC Connect Str". A button with 3 dots to the right of the property should appear. Click on this button.

Microsoft Access

When the "Select Data Source" window appears, highlight your ODBC connection that you configured at the beginning of this tutorial. Then click on the OK button.

Microsoft Access