Crerating a List of Queries for Documentation

[susanmgarrett]

I'm attempting to create documentation for an existing Access database - literally, it's a work-flow document.

It was relatively easy typing out the list of tables, modules, and Macros, but I have god-only-knows how many queries.

Is there any way to export a text list of query names to include in my documentation?

Regards and thanks!

Susan

 

[KeithG]

There is a system table called MSysQuiries and it contains information on all of your quries in your database. You can even query the table with the query builder. To view the table select Tools\Options\ViewSystemObjects

 

[Pat Hartman]

The table MSysObjects contains a list of all database objects. This is a list of what the type codes mean:

Type	TypeDesc
-32768	Form
-32766	Macro
-32764	Reports
-32761	Module
-32758	Users
-32757	Database Document
-32756	Data Access Pages
1	Table - Local Access Tables
2	Access Object - Database
3	Access Object - Containers
4	Table - Linked ODBC Tables
5	Queries
6	Table - Linked Access Tables
8	SubDataSheets

Add this table to your database and join it to the MSysObjects table on the Type field. Microsoft does not document the MSys tables and recommends that you not depend on them being the same from version to version. I developed this list of codes by examining my own databases. It is possible that it is not complete so use a left join.

 

[AccessJunkie]

You could try my free add-in here that documents several areas of your database:

http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html