Anyone have a sample DAO program that prints out metainfo on tables and
fields? VB6 will do, I suppose. I need to do it from C# or C++.

Does it have to be DAO? I know you can do it via ADOX (ADO Extensions)
You can look up these objects in the ADOX help file. That's your best bet.

For Table Names:
=============

Dim cat As New ADOX.Catalog
cat.ActiveConnection = YourConnection

Dim table As New ADOX.table
For Each table In cat.Tables
msgbox table.Name
Next


For Fields:
========

Dim tblTable As ADOX.table
Dim catCatalog As New ADOX.Catalog

catCatalog.ActiveConnection = YourConnection

Set tblTable = catCatalog.Tables("TableName")

For each Column in tblTable.Columns
msgbox Column.Name 'I think
Next Column


"Siegfried Heintze" <sieg_heintze (AT) yahoo (DOT) com> wrote