To Create DSN for MSAccess Database do following steps.
1. Access your control panel
2. Click on ODBC.
3. Click on Add New ODBC DSN
4. In the Connection Name, enter the DSN name, in the driver, select Microsoft Access Driver and click ok.
5. In the DB File Path enter the complete path (c:\inetpub\vhosts\domainname.com\httpdocs\file or foldername) to your database and click on Test Connection. If the connection is successful, click on Next.
6. Click on Finish.
After the Data Source Name connection is configured, it appears in the list on the ODBC Management page. To remove a data source name, select the corresponding checkbox and click Remove Selected. You will then be prompted to confirm removing. Select the checkbox to confirm and click OK.
