Set up or change ODBC data sources - Access

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Set up or change ODBC data sources

Applies to: Microsoft Office Access 2003

Open Microsoft Windows Control Panel and then double-click the Administrative Tools icon. Double-click on the Data Sources (ODBC) icon.
Select the User DSN, System DSN, or File DSN tab, depending on the type of data source to be modified.
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.
Complete the dialog boxes. For more information about the different options, click the Help button in each dialog box.

For more information on the ODBC interface, go to the ODBC Programmer's Reference section of MSDN.