We help IT Professionals succeed at work.

Fastest way of gaining an overview of an Access 2003 database

mranders
mranders asked
on
Is there a way of producing a report of some sorts about all the forms, tables, vb code etc in an Access database? I need to understand how a database that I have taken over works quickly.
Comment
Watch Question

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Tools>>analyze
Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
Sorry ... accidental Submit.

From the Menu:

Tools>>Analyze>>Documentator

Also ... since you have A2003, you can right click over any object and select Object Dependencies.  However, in order for this to work ... you must have the following option set:

 Tools>>Options>>General Tab
Track name AutoCorrect Info.
Note ... **Do Not* check Perform name Auto Correct ... *do not*

Also ... a GREAT tool:

http://www.rickworld.com/products.html#Find%20and%20Replace%209.0

mx


Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
If you want to invest some money, FMS's Total Access Analyzer does a very indepth anaylsis of your database (www.fmsinc.com)

Author

Commented:
Thanks both of you. Total Access Analyzer looks good LSMC, but like you say an investment.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
F&R does a nice XRef ... but not a full blown Analyzer.  However, if you are going to work with Access ... you *will* need it.  Rarely a day goes by that I don't use it.

mx

Author

Commented:
Anybody know of a discount code :-)
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Never seen one for the FMS stuff. It's worth the money, especially if you do a lot of "rescue" work.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
"Anybody know of a discount code :-)"

Yes: Tools>>Analyze>>Documentator

Of course, you git what you pay for :-)

mx

Author

Commented:
Thanks. I'll go for Rick's F&R for now and FMS' Total Access Analyzer when I get rich.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.