Exercise 1: Set up an ODBC connection for an Access database
 
 
 

Set up an ODBC connection for the Microsoft Access database using the Administrative Tools control panel in Windows.

NoteThis exercise uses the AnalyzeMap1.dwg map you created and modified in the previous exercises.

To set up an ODBC connection for the Access database

  1. From your Windows desktop, click Start Settings Control Panel and open the Administrative Tools control panel.
  2. In the Administrative Tools window, double-click Data Sources (ODBC).
  3. In the ODBC Data Source Administrator dialog box, click Add.
  4. In the Create New Data Source dialog box, click Microsoft Access Driver (*.mdb) and click Finish.
  5. In the ODBC Microsoft Access Setup dialog box, for Data Source Name, enter Parcel_Owners.
  6. Enter a description, for example, "Parcel owner information."

    Name the data source.

  7. Under Database, click Select.
  8. In the Select Database dialog box, navigate to the sample files and select the Assessor.mdb file.

    Specify the database for this data source.

  9. Click OK in the Select Database, ODBC Microsoft Access Setup, and ODBC Data Source Administrator dialog boxes.
  10. Close the Administrative Tools control panel.

To continue this tutorial, go to Exercise 2: Connect to the Access database.