DSN for access database is only used for the experiment purpose because the this database not provide efficient and large data storage. Mainly it is used by student they learn programming with database access.
So let’s see how to create DSN for access database.
Following step’s is used which is as following:-
In first step create access database by using Microsoft Office 2003/ Microsoft Office 2007/ Microsoft Office 2010.
and save this access database in c:/ directory.
let’s look in figure
|save as window of database created using access of microsoft office|
|create table figure in access database|
In this step open ODBC Data Source Administrator.
to open ODBC Data Source Administrator first click on “start button” and go to “control panel” and click on “Administrative Tools” in this window click on ODBC Data Source Administrator. which is look’s like
|ODBC data source administrator window|
After that click on Add button of ODBC Data Source Administrator window. by clicking this window new window appears title is “Create New Data Source”. select appropriate driver for data source
in this case of Access database selected is shown in diagram
|Create new data source window for select driver|
after that click on Finish button then again new window open title as “ODBC Microsoft Access Setup”
In this window enter the Data Source Name in text field
and click on select button and browse the saved database and click on OK button of “Select Database” window
|ODBC microsoft access setup window for dsn name|
and then again click on OK button of “ODBC Microsoft Access Setup” window.
and again click on OK button of “ODBC Data Source Administrator” window.
If all the above four step’s complete then the Data Source Name for Access database is created.
For better understand the procedure of creating DSN you can view video tutorial.