How to create DSN for an Access database
Author: Asif
You can connect to an Access database within an ASP page with different methods. This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine.
Open Control Panel window, you will see different icons as shown in Pic 1.
Doubble click on ODBC Data Source Administrator icon.
Pic 1.
Now you will see ODBC Data Source Administrator window (as shown below).
Select System DSN tab, and click Add.
Pic 2.
To Create a new DSN for an Access database, Select Microsoft Access Driver(*.mdb) and click Finish.
Pic 3.
Now you need to enter a DSN name that you like to use, I am using MyDSN. You have different options here. If you have already created an Access database you can select for this DSN or you can create a new Access database. Select the database you have created and Click ok.
If you like you can supply default login name and password by clicking on Advance button.
Pic 4.
You will be able to see your new DSN in the list of System DSN.
Click ok.
Pic 5.
After a System DSN has been created you can use it within any ASP page located on the same computer.