AllTables VS TableDefs

[Tom P.]

Using the DAO TableDefs collection I can iterate through
the properties of all the tables in the database and
determine which are linked and using what ODBC string. (I
have linkes to multiple non-access databases...)

Can this be done with the AllTables collection? I could
not determine how to get to the individual table
properties other than simple stuff like the name. I'd
like to both see and alter (reconnect really) the
connection string for a linked table and don't want to use
DAO to do it because presumably DAO is the "old" way.

Problem is I can't find the new way...

Thoughts?

 

[Allen Browne]

The perception that
DAO is the "old" way
represents advertising hype and not the reality that DAO is the library
designed especially for Access, and is generally the fastest, most suitable,
most efficient approach. In some cases (such as setting the Display Control
of a field in a TableDef), it is the ONLY way.

Go ahead and use the Connect property of the TableDef.

 

[Tom P.]

Thanks. That's what I needed to know. I appreciate the
reply.