Identifying Linked Tables

[Synergy]

Hello,

I would like to iterate through the tables in my DB and populate a table
with the names of all linked tables, but cannot find a property to identify
the Lined tables. Is there one?

God Bless,

Mark A. Sam

 

[Rick Brandt]

Hello,

I would like to iterate through the tables in my DB and populate a table
with the names of all linked tables, but cannot find a property to identify
the Lined tables. Is there one?

If the Connect property of the TableDef is not blank, then it is a linked
table.

 

[Synergy]

Thanks, that is what I need.

 

[Van T. Dinh]

A Query with the following SQL String:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "MSys*" And
(MSysObjects.Name)<>"Engine")
AND ((MSysObjects.Type)=6));

Should give you the names of all linked Tables.