This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine. To do that you need to follow a couple of steps:
Open the ‘ODBC Data Source Administrator’ ( Start -> Control Panel -> Administrative Tools -> Data Sources )
Flip to the System DSN tab
Click Add…
In the box that will appear you should select the Microsoft Access driver and click Finish
Type in a name that is easily remembered and relevant to your database in the ‘Data Source Name’ textbox
Click Select and browse to your local database file
Click OK all the way out
You have now created a DSN which will come in handy when you try to connect and retrieve information from your database.
