Manage Database Properties/Database Documenter

L

LisaH

in Access 2007 -
All I want is a list of the tables, queries, reorts, etc in my databse. If
I could print the results from selecting Manage; Database Properties;
Contents that would be perfect. Database Documenter is way more than I
need.
Years (and years) ago, someone shared a query that would list databse
properties/contents. It used a table that isn't shown under Tables. Does
anyone have any idea how to do this?
This was a really good tool for documenting databases and processes.

Thanks for any help
 
J

Jerry Whittle

SELECT IIf([MSysObjects].[Type]=1,
'TABLE',IIf([MSysObjects].[Type]=5,
'QUERY',IIf([MSysObjects].[Type]=-32768,
'FORM',IIf([MSysObjects].[Type]=-32764,
'REPORT',IIf([MSysObjects].[Type]=-32766,
'MACRO',IIf([MSysObjects].[Type]=-32761,
'MODULE',IIf([MSysObjects].[Type]=-32756,
'PAGE',IIf([MSysObjects].[Type]=8,
'RELATIONSHIPS',IIf([MSysObjects].[Type]=6,
'TABLE LINKED',
'Unknown'))))))))) AS ObjectType,
MSysObjects.Name,
MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "~*"
And (MSysObjects.Name) Not Like "Msys*")
AND ((MSysObjects.Type) Not In (2,3)))
ORDER BY IIf([MSysObjects].[Type]=1,
'TABLE',IIf([MSysObjects].[Type]=5,
'QUERY',IIf([MSysObjects].[Type]=-32768,
'FORM',IIf([MSysObjects].[Type]=-32764,
'REPORT',IIf([MSysObjects].[Type]=-32766,
'MACRO',IIf([MSysObjects].[Type]=-32761,
'MODULE',IIf([MSysObjects].[Type]=-32756,
'PAGE',IIf([MSysObjects].[Type]=8,
'RELATIONSHIPS',IIf([MSysObjects].[Type]=6,
'TABLE LINKED',
'Unknown'))))))))),
MSysObjects.Name;
 
L

LisaH

So simple, yet so difficult to re-remember.
Thank you so much!!

Jerry Whittle said:
SELECT IIf([MSysObjects].[Type]=1,
'TABLE',IIf([MSysObjects].[Type]=5,
'QUERY',IIf([MSysObjects].[Type]=-32768,
'FORM',IIf([MSysObjects].[Type]=-32764,
'REPORT',IIf([MSysObjects].[Type]=-32766,
'MACRO',IIf([MSysObjects].[Type]=-32761,
'MODULE',IIf([MSysObjects].[Type]=-32756,
'PAGE',IIf([MSysObjects].[Type]=8,
'RELATIONSHIPS',IIf([MSysObjects].[Type]=6,
'TABLE LINKED',
'Unknown'))))))))) AS ObjectType,
MSysObjects.Name,
MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "~*"
And (MSysObjects.Name) Not Like "Msys*")
AND ((MSysObjects.Type) Not In (2,3)))
ORDER BY IIf([MSysObjects].[Type]=1,
'TABLE',IIf([MSysObjects].[Type]=5,
'QUERY',IIf([MSysObjects].[Type]=-32768,
'FORM',IIf([MSysObjects].[Type]=-32764,
'REPORT',IIf([MSysObjects].[Type]=-32766,
'MACRO',IIf([MSysObjects].[Type]=-32761,
'MODULE',IIf([MSysObjects].[Type]=-32756,
'PAGE',IIf([MSysObjects].[Type]=8,
'RELATIONSHIPS',IIf([MSysObjects].[Type]=6,
'TABLE LINKED',
'Unknown'))))))))),
MSysObjects.Name;

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


LisaH said:
in Access 2007 -
All I want is a list of the tables, queries, reorts, etc in my databse. If
I could print the results from selecting Manage; Database Properties;
Contents that would be perfect. Database Documenter is way more than I
need.
Years (and years) ago, someone shared a query that would list databse
properties/contents. It used a table that isn't shown under Tables. Does
anyone have any idea how to do this?
This was a really good tool for documenting databases and processes.

Thanks for any help
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database documenter 3
Database documenter wanted 9
Documenter into CSV or Excel 3
Access 2007 Data Dictionary Reporting Tool 5
database structure / contents 2
Database content 4
Where did 'Manage' database properties go in Access 2010? 1
Database in partially converted state!!! 1

Top