MS Access Linked Table Manager full network path

Question

Is there any way of inputting the full network path in MS Access Linked Table Manager?

enter image description here

What are you asking here? by full network path do you mean a UNC path (i.e. \\server\share\folder...\)? The examples you're showing are all in a locally saved database so don't have a network path. — citizenkong, Jun 26 '15 at 08:25
@citizenkong thats correct the full network path, UNC path (i.e. \\server\share\folder...) , i've updated my question — Elixir, Jun 26 '15 at 21:12

score 2 · Accepted Answer · answered Jun 26 '15 at 21:36

If your target network location is accessible via Windows Explorer, you should be able to choose it in the Select New Location dialog from the Linked Table Manager.

In the Linked Table Manager, place a checkmark next to a linked table, ensure the "Always prompt for new location" box is checked, and click OK to bring up the Select New Location dialog. Then navigate to your network location and select the source database:

enter image description here

After clicking Open in that dialog, you should be returned to the Linked Table Manager and see that link has been updated with the UNC path:

enter image description here

If that approach doesn't work in your situation, I don't think the Linked Table Manager can do it. In that case, you could use VBA code to modify the .Connect property of the linked table's DAO.TableDef

great thanks I'll check this out once I get back to working on the database , thanks again — Elixir, Jun 26 '15 at 21:56

MS Access Linked Table Manager full network path

1 Answers1