The drivers are installed with some Microsoft products such as Developer's Studio, Excel, and Access. If you think you might have them installed, continue with the next section. If the Create New Data Source window does not offer Microsoft Access Driver as an option, return here to install Access drivers.
The file dataacc.exe comes with Microsoft Outlook 98, Office 97 and the Office 97 products in the Valupack folder on the CD. It installs Access drivers.
You can download Access drivers from Microsoft's Web site. When this document was written, Access drivers were available at http://www.microsoft.com/outlook/enhancements/dataacc.asp. They could also be found at http://www.microsoft.com/data/download.htm by following the link to the latest Microsoft Data Access Components release.
If access drivers are not currently available from these web sites, visit the main Microsoft Web site and search for the drivers. Search for "Access ODBC drivers" or a similar string.
Follow Microsoft's instructions for installing the Access driver.
Click the System DSN tab to change to
the second page.
On the second page (System DSN),
click the Add button.
Select the Microsoft Access
Driver and click Finish.
In the ODBC Microsoft Access
Setup panel, fill in the Data Source Name as query.
Under Database, click the Select button.
Navigate to the Samples\ODBC directory under the Host Publisher directory, and select query.mdb. Click OK repeatedly to exit the ODBC administration windows.
Click on the Search button and you
should see that Kelly Allen's Employee ID is 1812.