finding the source of a linked table to a front end database

[AshikHusein]

I have been working on quite a few multi user Access projects in the past few months with a backend and a front end which has linked tables.

I would like to know if there is any way to find out the source of a table linked to the front end and where would its location be on the network.

 

[The_Doc_Man]

In Access Help, look up the TableDef object (which is a member of the TableDefs collection). Find its properties. One of them will be what you want. You can't easily get to this property except through VBA unless all you want is to look at the properties with a right-click on the table icon.

 

[AshikHusein]

Thank you very much for your response.

I also discovered another way to find that.

You can use the "document ananlyzer" or even the linked table manager to view the path and backend file.

Regards,

Ashik

 

[Pat Hartman]

The linked tables manager tends to cut off names because its size can't be expanded so I open the MSysObjects table to see the complete path.