How To Setup an Access DSN

Follow these steps to create a new DSN:
  1. Open the control panel

     

  2. Next, add a user DSN by clicking on he Add button on the screen below:

     

  3. After clicking the Add button, you will see the following screen:

    Select "Microsoft Access Driver", then click the Finish button.

     

  4. The following screen will appear:

    Enter a name in the field "Data Source Name". For example, you can name it MyDatabase.

     

  5. Click on the button "Select" to choose an Access database. The "Select database"dialog will appear:

    Click the OK button after you have selected the Access database.

     

  6. Click the OK button to close the "ODBC Microsoft Access Database" dialog. You should now see the MyDatabase in the alphabetical list of DSNs:

     

  7. You are finished!