How do I change 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.

How do I change the Access database connection?

1Step 1: Change the main data connection in the form template. On the Tools menu, click Convert Main Data Source. ... 2Step 2: Select the database tables. In the Select Table dialog box, click the name of the primary table or query, and then click OK. ... 3Step 3: Preview, publish, and test the form template.

How do I reset my ODBC connection?

To delete a data source by using ODBC Administrator1In Control Panel, open Administrative Tools, and then double-click either ODBC Data Sources (64-bit) or ODBC Data Sources (32-bit). ... 2Click the User DSN, System DSN, or File DSN tab.3Select the data source to delete.4Click Remove, and then confirm the deletion.

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 change the DSN on a linked table in access?

Edit a data source1Select External Data > Linked Table Manager. ... 2In the Linked Table Manager dialog box, select the data source, hover over the data source, and then select Edit.3Change the information in the Edit Link dialog box. ... 4Select Finish.

Expert · Answer