linked table info

[marks416]

Hi,

I have a third party Access application that the front end tables link to different back end databases.

I want to output a list to show which table link to which database.

Thanks

M

 

[marks416]

Would you please give me a hit how to do this.

Thank you for help

M

 

[Ed2020]

You can query the MSysObjects table to get this information:

SELECT MSysObjects.Name, IIf(MSysObjects!Database<>"",MSysObjects!Database,CurrentDB.Name) AS Location
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "MSys*" And (MSysObjects.Name)<>"tblRestrictedText") AND ((MSysObjects.Type)=1)) OR (((MSysObjects.Name) Not Like "MSys*" And (MSysObjects.Name)<>"tblRestrictedText") AND ((MSysObjects.Type)=6))
ORDER BY MSysObjects.Name;

Ed Metcalfe.

Please do not feed the trolls.....

 

[JerryKlmns]

SELECT M.Name, 
       M.ForeignName
       M.Database
FROM MSysObjects As M
WHERE M.Type=6
ORDER BY M.Name;