Printing Database Objects "all" of them without using Document ana

J

Judy

I have an existing database that I am trying to communicate with one of the
owners about what to keep and not to keep. Is there a way to print out on
paper the contents of the database? I have used the File/DB
Properties/Contents and also the Document analyzer...what i am looking for is
a digital or iconic representation of it. Sort of what i look at when i open
the database view! Is there such a tool within ACCESS or another program
will do that?
 
A

Allen Browne

If you just want a list of the tables, queries, forms, etc, try this query:

SELECT MsysObjects.Type, MsysObjects.Name FROM MsysObjects
WHERE (((MsysObjects.Name) Not Like "~*" And (MsysObjects.Name) Not Like
"MSys*"))
ORDER BY MsysObjects.Type, MsysObjects.Name;

You can use the Type to determine what kind of object it is, e.g.
1= table
5 = query
4 = attached table
6 = ODBC attached table
-32768 = form
-32764 = report
-32761 = module

For a more complete documenter, see:
http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html
 
L

Larry Linson

Judy said:
I have an existing database that I am trying to communicate with one of the
owners about what to keep and not to keep. Is there a way to print out on
paper the contents of the database? I have used the File/DB
Properties/Contents and also the Document analyzer...what i am looking for
is
a digital or iconic representation of it. Sort of what i look at when i
open
the database view! Is there such a tool within ACCESS or another program
will do that?
Click to expand...

The Access object definition information is accessible by VBA code. I am not
certain what you mean by "digital or iconic representation of it". The
database window simply lists the different objects by name in text.

You can use the Database Documeter, by selecting options, to create a simple
Report that prints minimal information about each.

Or, you can write VBA code to collect as much, or as little, information
about the objects, and save it in a table for reporting however you prefer.

There are third-party tools, ranging in cost from free to moderately
expensive, whose purpose is to assist development including documenting
databases. I'm certainly not familiar with all of them, and not
understanding any better than I do what you want, wouldn't make
recommendations.

Larry Linson
Microsoft Access MVP
 
J

Judy

Allen:

Thank you for the website link for add-ins, it did exactly as I needed, it
printed out exact objects, reports, tables, etc in access in an easy to read
format. I can't thank you enough. I will also go to your website from now
 
Top