Configuring Microsoft Access ODBC DSN
Select Microsoft Access ODBC Driver, and then click Finish. The ODBC Microsoft Access Setup dialog box appears, as shown below:
- In the Data Source Name box, enter the name of the data source you want to access. It can be any valid name that you choose.
- Click Select button to select or create .mdb file you want to access using the DSN.
- Click Advanced button if you need to add login info. Set Advanced Option dialog appears
Enter Login and Password into appropriate fields and click OK button to save configuration.