How to document MS Access .ADP objects

fhcdaver
fhcdaver used Ask the Experts™
on
I have a requirement to document the forms and Modules used in an Access .adp project.  The project us a front end to a SQL server database.    I need a listing of the forms and modules, descriptions, last update date, etc.

Is there a table or some other resource where this info is stored that can be queried or otherwise dumped?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

Commented:
What version of Access? Most recent versions have a "Documenter", which can be used for basic stuff.

If you need cross-checking, usage, etc then Total Access Analyzer is the best tool I've found for that: http://www.fmsinc.com/MicrosoftAccess/BestPractices.html
fhcdaverpresident

Author

Commented:
Access 2010.  But what we think is happening is that this is an .ADP.    If it were a full access database and app, then some of the tools we're familiar with would be good.  But since it's an ADP, even the basic objects like forms dont get documnted.  

Or....maybe I'm not looking in the right place.  Please tell me where the Documenter is....
Most Valuable Expert 2012
Top Expert 2014
Commented:
It's in the Database Tools ribbon tab, in the Analyze section.
fhcdaverpresident

Author

Commented:
Thanks Scott, I'll give it a try.
fhcdaverpresident

Author

Commented:
Hi Scott,
Sorry for the dealy. That worked great. Thank you

Dave

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial