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 Jump to 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.

Retrieved from "https://htyp.org/mw/index.php?title=connecting_to_an_ODBC_data_source_in_MS_Access_97&oldid=5785"