To set up an ODBC data source
Step 1: Go Start > Settings > Control Panel.
Step 2: Double-click on the ODBC Data Sources icon. This starts up ODBC Data Source Administrator dialog. ODBC requires that any database you wish to use is added as either a user DSN (if you want it to be available to you only) or a system DSN (if you want it to be available to all users on this machine). Depending on your preference, you must now select the User DSN or the System DSN Tab.

The ODBC Data Source Administrator
Step 3: Click Add. This fires up the 'Create New Data Source' dialog. (A data source is essentially a link to an existing database).

Create a new Data Source
Step 4: Select your database driver, for example, the Microsoft Access Driver (This requires Microsoft Access to be installed). Click Finish.

Database name, description and selection
Step 5: In the ODBC Microsoft Access 97 Set-up dialog, give the database a name and description, then click Select and select the database file. Click OK, and exit the ODBC Data Source Administrator. Your data source is now set up!
|