Guide

1. Open the Access database where you want to link the tables. Go to the 'External Data' tab in the ribbon.

2. Click 'New Data Source', select 'From Database' and click on the 'Access' button.

3. If you choose 'Access', click 'Browse' to locate the source Access database.

4. When prompted, choose the 'Link' option. This ensures the data remains in the original location, and you interact with it in your current database.

5. Click 'OK'.

6. A dialog box will appear listing available tables or sheets. Select the table you want to link. Click 'OK' to confirm.

7. The linked tables will appear in the 'Navigation Pane' with a small arrow icon, indicating they are linked.