How to check the path of the linkage?

  • Thread starter Thread starter Sming
  • Start date Start date
S

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