How to edit link for tables

[jim]

I have an access program but the link for all tables are
in the following standard:
c:\myDocuments\table.mde
how can I change all the path and link for tables to the
UNC path standard?
i.e. \\group\computername\file??????
any method that needn't deal with VB coding???

 

[JC]

You should be able to change the path in the properties
of it. That is what i would do.
JC

 

[Allen Browne]

If you don't want to loop through the TableDefs to change the Connect
property and RefreshLink, you could try the Linked Table Manager under Tools
| Database Tools.

Alternatively, you could delete all the linked tables, and reattach them
again with File | Get External | Link.

 

[Douglas J. Steele]

Just a note. If you're using the Linked Table Manager (or if you're linking
them through File | Get External | Link), you can specify a UNC by
navigating to the MDB file through Network Neighborhood, rather than
navigation through a linked drive.