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'
Flip to the System DSN tab
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.
|Copyright © 2005-2007 www.WebCheatSheet.com All Rights Reserved.|