Identifying Linked Tables

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" <NoName@NoMail.Com> wrote in message
news:%23Pg0p84pDHA.1408@TK2MSFTNGP11.phx.gbl...
> 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.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Synergy previously wrote:

> 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
>
>
>
Using DAO tabledefs you can test the tabledef.Connect property for not ""

Regards

Peter Russell

Thanks, that is what I need.

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.

--
HTH
Van T. Dinh
MVP (Access)



"Synergy" <NoName@NoMail.Com> wrote in message
news:#Pg0p84pDHA.1408@TK2MSFTNGP11.phx.gbl...
> 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
>
>