Getting location of linked tables database.

[Dan_T]

Hi,

I wish to return the path for the database where a linked table is located. I will continue looking myself but if anyone has the answer to hand I would appreciate it.

Many Thanks

Dan

 

[ghudson]

SELECT MSysObjects.Name, MSysObjects.Database
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=4 Or (MSysObjects.Type)=6))
ORDER BY MSysObjects.Name;