How do I get metadata in access database?

[Guest]

How do I read the metadata for tables, fields, queries, etc.. in access
database. In Oracle there are standard tables like ALL_TABLES to provide this
info.

Thank you
Mohammad

 

[Scott McDaniel]

How do I read the metadata for tables, fields, queries, etc.. in access
database. In Oracle there are standard tables like ALL_TABLES to provide this
info.

If you want a simple printout, the Documenter will do some of this for you (Tools - Analyze - Documenter).

If you want more information, you can loop through the DAO.TableDefs collection, or the ADOX.Tables collection, and get
the information from there.

There's also the MSysObjects table, which holds some information.

Thank you
Mohammad

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[John W. Vinson]

On Tue, 3 Jul 2007 02:32:02 -0700, METADATA - ACESS DB <METADATA - ACESS

How do I read the metadata for tables, fields, queries, etc.. in access
database. In Oracle there are standard tables like ALL_TABLES to provide this
info.

Oracle stores this information in Oracle tables - Access doesn't, at least not
in anything like as simple a way. There are some hidden systems tables (you
can use the Options menu to make them visible), but their structure is not
documented or even stable from version to version, and - just for instance -
it is not apparent in these tables where the fields are defined.

You can use VBA code to look at the Tabledefs collection and then the Fields
collection in each tabledef, and similarly the Queries collection. But it's a
very different environment from Oracle!

John W. Vinson [MVP]