Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

linked table info

Status
Not open for further replies.

marks416

IS-IT--Management
Oct 24, 2007
39
CA
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
 
Would you please give me a hit how to do this.

Thank you for help

M
 
You can query the MSysObjects table to get this information:

Code:
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.....
 
Code:
SELECT M.Name, 
       M.ForeignName
       M.Database
FROM MSysObjects As M
WHERE M.Type=6
ORDER BY M.Name;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top