Configuring a DSN for an Access database

To configure a data source name (DSN) for Access:

1. Select Start > Settings > Control Panel.
2. Double-click Administrative Tools.
3. Double-click Data Sources (ODBC).
4. Click System DSN.
5. Click Add to display a list of installed ODBC drivers.
6. Select the Microsoft Access Driver (.mdb) and click *Finish to open the ODBC Microsoft Access Setup dialog box.

7. Specify the values described in the following table:
   

   Field or Option	Explanation	Example
   Data Source Name	A user-specified name for the specific RDBMS. It is the name that appears in the Data Source Selection dialog box	LocalAccessDBmarktg
   Description	Optional annotation for other users	This is a local access database for marketing.

8. Click Select in the Database section of the dialog box to identify the specific instance of a data source, if you have already created a Visualizer database. Enter the proper directory location of the MS Access database file. For example,
   D:\dbfiles \access \visual.mdb
   If you want Access security, follow Step 10 through Step 12.
9. Specify a database in the System Database section of the dialog box.
10. If you want to specify a userid and password, click Advanced and enter the login name and password, and then click OK.
11. Click OK to return to the Data Source Administration dialog box where you can view driver specifics and available data sources.
12. Set the permissions for the database. You must do this before the database is accessed from Visualizer, or before any summary redirection is done.
    To set permissions for the database:
    1. Open the database in Access and choose Tools > Options.
    2. On the View tab, select System Objects and click OK. 
    3. Select Tools > Security > User and Group Permissions. 
    4. In the Object Name: box , select MSysObjects.
    5. In the User/Group: box, select User/Group Admin.
    6. Select all of the boxes, then click OK.
    7. Close the database.