Help with printing link table manager

[Guest]

I have a table which includs a list of linked table names in the front end
and I would like to add next to each table name , the link path where this
table is linked can some one help?
thanks
Al

 

[Guest]

Try this SQL using the MSysObjects table

SELECT MSysObjects.Connect, MSysObjects.Database, MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=6 Or (MSysObjects.Type)=1))

 

[Guest]

Thank you it works
Al

Try this SQL using the MSysObjects table

SELECT MSysObjects.Connect, MSysObjects.Database, MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=6 Or (MSysObjects.Type)=1))