How to edit link for tables

  • Thread starter Thread starter jim
  • Start date Start date
J

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???
 
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.
 
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.
 
Back
Top