Set up or change ODBC data sources

Microsoft Office Access 2003

Set up or change ODBC data sources

  1. Open Microsoft Windows Control Panel and then double-click the Administrative Tools icon. Double-click on the Data Sources (ODBC) icon.
  2. Select the User DSN, System DSN, or File DSN tab, depending on the type of data source to be modified.
  3. Do one of the following:

    To define a new data source for a currently installed driver, click Add.

    To modify the definition of an existing data source, select the data source from the list. If you are modifying a file DSN, find the appropriate folder in the Look In box (use the Up control if necessary), and then select the data source from the folder. Click Configure.

  4. Complete the dialog boxes. For more information about the different options, click the Help button in each dialog box.