Identifying Linked Tables

  • Thread starter Thread starter Synergy
  • Start date Start date
S

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
 
Synergy said:
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?
Click to expand...

If the Connect property of the TableDef is not blank, then it is a linked
table.
 
Synergy said:
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
Click to expand...
Using DAO tabledefs you can test the tabledef.Connect property for not ""

Regards

Peter Russell
 
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.
 
Back
Top