Access 2007 Meta Data

[Daniel Jacobs]

I want to create a set of custom reports on the objects inside my database
(e.g. table and column descriptions, relationships etc.

Can somebody tell me where i can find a model/description/list of the meta
data (e.g. sysobjects) so that I can access this via SQL.

 

[Allen Browne]

Access does not expose the field names to JET SQL.

You can get it programmatically like this:
http://allenbrowne.com/func-06.html

There is a built-in documenter that reports them, or here's a better one:
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html