How do I change the Access database connection?

How do I change the ODBC connection in an Access database?

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

How do I connect Microsoft 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 unlink an Access database?

It is easy to unlink tables that are linked to your Access database. In the Navigation pane, simply select the table you want to unlink and then press the Delete key or click the Delete command in the Records group on the Home tab on the ribbon. Access displays the confirmation message. Click Yes to unlink the table.

How do I change the path in Access?

There is a "Linked Table Manager" on the External Data tab of Access (at least the version I have). You would click this and select the tables you want to relink. Check the box for "Always prompt for new location". After clicking the OK button, you will be prompted for the new location.