'Metadata report from access'

[ChrisInTheNorth]

Hi everyone

Is there are way to generate a list of all the objects created in my Access DB, in 'report forma report', or that I could transfer to, maybe, Word.

Tried searching for 'metadata report' in helps screens and forums, though in truth not sure what it would be called.

[June7]

What is 'report forma report'?

What version of Access?

Access 2007 ribbon: DatabseTools>DatabaseDocumenter
Will generate a very large report and runs very slow and outputs only to printer.

Unhide system tables. Look at MSysObjects table. You can build Access report of these records or export to Word. But DO NOT modify the records.

[alansidman]

Which version of Access are you using. The instructions for accessing the hidden system tables is slightly different depending on the version of Access you are using. But briefly you need to unhide the system tables - locate the MSysObjects table and note the fields you need to query. Create a query and use this query as your record source for a report. Make sure to hide these tables after you finish

[meratigoerr]

You might also have some luck with the msysNameMap table. it lists all of the database objects and a type ID. You can use the type id to sort them on a report. (basically the same thing as the MsysObjects table, but with less data in it to accidently mess up.)

[ChrisInTheNorth]

Thanks guys, I've been able to build a query from MSysObjects to give me what I needed