Identifying source mdb for a linked table. 2

[Norwich]

Hi,

I've 'inherited' support for an access db on a customer network. It consists of a large number of queries, forms and macros on a local mdb file with half a dozen linked tables from another. The problem is that I cannot identify to which other mdb file(s) these links tables refer.

It's a bit of an 'RTFM' question but if anyone can point me towards how to identify the remote mdbs, I would be very gratful.

Many thanks,

Norwich

 

[tlbroadbent]

Create a new query. Paster the foloowing into the SQL View. Whne execute it should show all linked tables and the sources.

SELECT msysobjects.Name, msysobjects.ForeignName, msysobjects.Database, msysobjects.Type
FROM msysobjects
WHERE msysobjects.Type=6;
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[larryww]

This is the poor man's macro to do it, but like the comment says, using 3rd party PUP2000 is really the way to fly.

Sub pmShowLinks() 'PUP2000 add-in far superior,but this abbrev. version is by Walkenbach too
Dim Lnk
On Error Resume Next
For Each Lnk In ActiveWorkbook.LinkSources(xlExcelLinks): Debug.Print Lnk: Next
For Each Lnk In ActiveWorkbook.LinkSources(xlOLELinks): Debug.Print Lnk: Next
End Sub

 

[Norwich]

Thanks all, worked a treat.