How do I open a linked table manager in access?

How do I Access linked table manager?

Select External Data > Linked Table Manager. Tip In the navigation bar, you can hover over the linked table name to see connection string and other information. In the Linked Table Manager dialog box, select a data source or individual linked tables. You may need to Expand (+) entries in the Data Source column.

How do I Access a linked database?

The Get External Data - Access Database import and link wizard opens. In the File name text box, type the name of the source database or click Browse to display the File Open dialog box. Click Link to the data source by creating a linked table, and then click OK. The Link Tables dialog box opens.

How do I change the linked table manager in Access?

1Open the database that contains links to tables.2On the Tools menu, point to Database Utilities, and then click Linked Table Manager.3Select the Always prompt for new location check box.4Select the check box for the tables whose links you want to change, and then click OK.View, refresh, or change the file name and path for linked tables (MDB)

How do you open the relationship table in Access?

On the Database Tools tab, in the Relationships group, click Relationships. On the Design tab, in the Relationships group, click Add Tables (or Show Table in Access 2013). Select one or more tables or queries and then click Add.