VB NET 2005 MSACCESS list all the DB Metadata

jhkraft · March 13th, 2008, 05:20 PM

With System.Data.OleDb
How can the Tables, Fields names, Field attributes (such as; max text length, required field, be listed.)
is there a collections for the MSAccess Tables, Table Columns, Column Type(2)and max lengths and other field limitations or requirement available in a VB NET program.

rickpowell · April 14th, 2008, 04:11 PM

I am looking for the same thing.

I would like to see the metadata for when a table was last modified (not it's design, but when the last record in the table was modified).

Seeing the Table creation date would be nice too.

Did you ever get any working code for this, and would you mind sharing it?
Thanks [email protected]