Where is the linked table manager in Access?

How do you find the linked table source in Access?

Find a linked table. If you have many linked tables, use the Search box at the top of the Linked Table Manager dialog box to find what you want. Enter text in the Search box. Access searches the Data Source Name and Data Source Information columns to find a match.

What is a linked table in Access?

When you link to a table in an Access database, Access creates a new table, called a linked table, which maintains a link to the source records and fields. Any changes you make to the data in the source database are reflected in the linked table in the destination database, and vice versa.

How do you unlink tables in Access?

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.