Hi Emily,
Lots of options for you.
1. Tools--Analyze--Documentor will print out a ton of stuff for you on database objects, but
carefully go through the options to avoid way too many pages.
2. Create some saved queries to run against the system tables, then just make a report from that.
--For Queries use:
SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((MsysObjects.Type)=5))
ORDER BY MsysObjects.Name;
--For Forms use:
SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((MsysObjects.Type)=-32768))
ORDER BY MsysObjects.Name;
--For Reports use:
SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((MsysObjects.Type)=-32764))
ORDER BY MsysObjects.Name;
--For Macros use:
SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((MsysObjects.Type)=-32766))
ORDER BY MsysObjects.Name;
--For Tables use:
SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((Left$([Name],4))<>"Msys") AND ((MsysObjects.Type)=1))
ORDER BY MsysObjects.Name;
--For Modules use:
SELECT MsysObjects.Name
FROM MsysObjects
WHERE (((Left$([Name],1))<>"~") AND ((MsysObjects.Type)=-32761))
ORDER BY MsysObjects.Name;
You could even make a report using all of the above queries to make one single report listing all
database objects. I have done this in the past with sub-reports.
3. I created a cool Access Add-In that will generate a slick report of all database objects. The
report is based on a template by MVP Doug Steele. It's as easy as Tools--Add Ins--Doug Steele Object
Documentor. Poof!! A nice report is created in just a few seconds and is saved in your database
where you can open it again at any time. All of the database objects are easily listed in a three
column report. However, I do not believe I can give it out without his permission since it was his
report to begin with.
