How to check the path of the linkage?

[Sming]

Hi,

I have one set of files in two computers, I link the
files in both locations, how can I find out the path
instead of deleting the old link and recreate a new one?

Thanks,
Sming

 

[John Nurick]

Hi Sming,

One way is like this:

Dim dbD As DAO.DataBase
Dim strS As String

Set dbD = CurrentDB()
strS = dbD.TableDefs("MyTable").Connect
'now parse the filespec out of strS.

 

[Guest]

Just right click on the linked table in excel and go to
Linked Table Manager. It will show you the path of all the
links in the file.