---

MS Access 2003: Create ODBC Connection

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

How to Create an ODBC Connection

The first step is to create an ODBC connection to your external database. This ODBC connection will be used by the pass-through query to access the tables directly in your external database.

If you don't already have an ODBC connection defined, you can create one by selecting Data Sources (ODBC) under the Control Panel.

When the ODBC Data Source Administrator window appears, select the User DSN tab. Then click on the Add button.

When the Create New Data Source window appears, select the ODBC driver that you wish to use. In this example, we've selected the driver called "Microsoft ODBC for Oracle". Click on the Finish button.

Next, enter the Data Source Name, Description, User Name, and Server for the ODBC connection. Then click on the OK button.

Now, when you return to the ODBC Data Source Administrator window, you should see the ODBC connection that you've just created.