Linked Tables

[Guest]

Hi,

I need to find out where a linked table is linking to in Access 2000. Can
anyone help? I've looked in the linked table manager but this only seems to
be for updating the links.

Thanks,

JM.

 

[ajetrumpet]

In the linked table manager window, it should show the address of the source file...it doesn't?

Or are you looking for the linked table's relationship with any other DB objects perhaps?

 

[Allen Browne]

You can parse it from the Connect property of the TableDef.

Here's a function to read it for you:
http://allenbrowne.com/ser-53code.html#GetDataPath
Pass in the name of the linked table, e.g.:
= GetDataPath("Table1")

 

[Joan Wild]

If you open the table in design view, you can choose View, Properties...The description property will tell you the path to the backend.