How can I determine table names in an mdb? 2

[steve728]

I'm an experienced MS Access VBA programmer that needs to know how to determine the table names of an mdb using vba code. I also need to then determine a table's field structure with VBA code.

Thank you!

Steve G.

 

[PHV]

Have a look at the TableDefs and Fields DAO collections.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[steve728]

I'm an ADO programmer. I don't work with DAO anymore. Is an ADO approach instead? When looking up "TableDef" alone I only get DAO references to it.

Steve

 

[PHV]

You may try to play with an ADOX Catalog object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RoyVidar]

Or take a look at the OpenSchema method of the connection.

Roy-Vidar

 

[danvlas]

Table names:

Select [Name] From MSysObjects Where Type=1 ?


Then...loop through the recordset to get the fields of each table

"Select * From " & rst("Name")

Then...For Each fld in rst2.Fields...check the name, type, length and so on?

ADO or DAO, what difference does it make?

Not bad with TableDefs though, for Jet.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html