connecting to an ODBC data source in MS Access 97

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

Navigation

computing: software: Windows 98/MS Access 97/ODBC: connecting to an ODBC data source in MS Access 97

Instructions

In MS Access, select File → Get External Data → Link Tables...:

MS Access 97 link tables menu item.png

From the "Files of type" dialog, choose "ODBC Databases" (it's the last entry; you have to scroll down a bit):

MS Access 97 Link dialog - ODBC Databases.png

Once you have selected "ODBC Databases", the "Link" dialog disappears and the "Select Data Source" dialog appears. Click on the "Machine Data Source" tab:

Win98 ODBC Select Data Source dialog.png

Select the data source you want to use, and press the [ Ok ] button. A dialog showing a list of tables available through that data source will appear:

MS Access 97 Link Tables dialog.png

Select the tables you want to use, and press the [ Ok ] button. The new links should appear in your MS Access database window.