Steps to Setting Up an ODBC Connection

  1. Select Start and Run. Type odbcad32 in the Open ComboBox and click on OK. You will get an ODBC Data Source Administrator dialog.

  2. Select the Add button on the right. You will get a Create Data Source dialog.

  3. Make sure that Microsoft Access Driver (.mdb) is selected and click on Finish. You will get an ODBC Microsoft Access Setup dialog.

  4. Type in the DataSource name (GradeData) and a Description (optional). Then click on Select. You will get a Select Database dialog.

  5. Select the drive and the directory where the database is located. You should then see the .mdb file on the left. Select it. You should see the name of the database appear in the DatabaseName text field. Then click on OK in the Select Database dialog.

  6. Click on OK in the ODBC Microsoft Access Setup dialog.

  7. Click on OK in the ODBC Data Source Administrator dialog.

  8. The ODBC DataSource GradeData is now ready to use.