How do I setup an ODBC connection in Access?

Question

Add an ODBC data source Click Start, and then click Control Panel. In the Control Panel, double-click Administrative Tools. In the Administrative Tools dialog box, double-click Data Sources (ODBC). . Click User DSN, System DSN, or File DSN, depending on the type of data source you want to add. . Click Add.

Where is the ODBC connection in Access?

From your Windows desktop, click Start Settings Control Panel and open the Administrative Tools control panel. In the Administrative Tools window, double-click Data Sources (ODBC). In the ODBC Data Source Administrator dialog box, click Add.

How do I create a connection to an Access database?

Here is how to create a connection to a MS Access Database:1Open the ODBC icon in your Control Panel.2Choose the System DSN tab.3Click on Add in the System DSN tab.4Select the Microsoft Access Driver. ... 5In the next screen, click Select to locate the database.6Give the database a Data Source Name (DSN).7Click OK.

How do I change the ODBC connection in Access?

Modifying an Existing ODBC Data Source1Select Database Connection Setup from the File menu to open the Database Connection Setup dialog. ... 2From the All Database Tree View, select an existing named ODBC data source.3Select the Options tab.4Click Setup or ODBC Administrator.

How do I create a DSN for an Access database?

Configuring a DSN for an Access database1Select Start > Settings > Control Panel.2Double-click Administrative Tools.3Double-click Data Sources (ODBC).4Click System DSN.5Click Add to display a list of installed ODBC drivers.6Select the Microsoft Access Driver (. ... 7Specify the values described in the following table:

Expert · Answer