Skip to content

Specify a Data Source

Open the Microsoft Windows Control Panel.

Screenshot from ODBC Client Capability Supplement

Select the 32bit ODBC icon. The ODBC Data Source Administrator dialog box will be displayed:

Screenshot from ODBC Client Capability Supplement

Press the Add… button. The Create New Data Source dialog box will be displayed:

Screenshot from ODBC Client Capability Supplement

Select the Microsoft Access Driver (*.mdb) option. The ODBC Microsoft Access Setup dialog box will be displayed:

Screenshot from ODBC Client Capability Supplement

Provide a name for the data source in the Data Source Name: text box. Provide a description of the data source in the Description: text box. In the System Database panel, make sure that the None button is selected.

Screenshot from ODBC Client Capability Supplement

The Data Source Name: is NewSource. To associate the Microsoft Access NewTest.mdb database with this data source, go to the Database panel and press the Select button. The Select Database dialog box will be displayed:

Screenshot from ODBC Client Capability Supplement

Select the Microsoft Access NewTest.mdb database, and press the OK button. You will return to the ODBC Microsoft Access Setup dialog box.

Screenshot from ODBC Client Capability Supplement

In the Database panel, the Database: descriptor displays the full path name for the NewTest.mdb file. Press the OK button. You will return to the ODBC Data Source Administrator dialog box. To exit, press the OK button.

Close the Microsoft Windows Control Panel.

From the ODBC Client Capability Supplement, version 8.9.1. Open this page in the PDF