Help with printing link table manager

A

Al

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
 
O

Ofer Cohen

Try this SQL using the MSysObjects table

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

Al

Thank you it works
Al

Ofer Cohen said:
Try this SQL using the MSysObjects table

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