Linked Tables

Hi Lorena

To modify a link to a table in another database you can right click and choose Delete.

Notice the prompt says this will only remove the link and not delete the table!

Then to link to another table or database select
External Data, Access (in Import group)
Choose Link to a data source by creating a linked table
Click the Browse button and select the location of the database, OK.
Then select the Table to link to and press Ok.

The linked table will now appear with a small blue arrow at the top left of the table icon.

There is also an option called Linked Table Manager when you right click the icon. This allows you to refresh a link but unfortunately not actually change it.

Please let me know if this helps and answers your question about changing link locations.

Regards
Doug Dunn
Best STL