How to set up a system DSN?

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.



Leave a Reply

Your email address will not be published.