
	Quick Find:		Search for:

Total Access Analyzer
Preview the Access 2007 Version (FREE!) Updated versions available for Access 2000, 2002, and 2003! Access 97 Version All Access Products
Why Analyzer?
Best Access Add-In Rave Reviews
for Users, Developers & Consultants Compare with Microsoft's Documenter
Analyzer Info:
Quick Tour Informational Video List of Errors, Suggestions, and Performance Tips Detected List of Reports Product Guide FAQs
Get Analyzer Now:
Convince Your Boss Check for Updates License Terms

"My company has purchased Total Access Analyzer. As the primary developer here, I can say that I love Access Analyzer. I wish I'd had this a year ago! Thanks to the entire FMS team!" - M. Garstin More Reviews

Microsoft Access Database Documentation and Analysis: Total Access Analyzer

Comparison to the Built-In Microsoft Access Database Documenter

Why bother getting Total Access Analyzer when Microsoft Access includes a built-in database documenter?

If you think the database documenter is all you need, think again! This comparison shows how Total Access Analyzer gives you the information you need to build better, more robust Access databases. Winner of every Best Access Add-in Award, Total Access Analyzer let's you take control of your databases.

The built-in Access database documenter is a basic tool that creates a limited set of documentation, but does not include the features you need to really understand what's happening in your database. It documents each object independently and does not consider the database as a whole.

Total Access Analyzer takes a different approach. It documents your entire database to reveal the hidden relationships among your database objects. That's the only way you can determine broken references, where objects are used, which objects are unused, etc. The extensive reports, error detection, suggestions, and other output makes it a must have for any serious Access user or developer!

Feature	Total Access Analyzer	Database Documenter
Top Reasons!
Object cross reference	YES Your entire database is examined to show how objects relate to each other.	None
Module Code Analysis	YES Comprehensive VBA code analysis including procedure and variable cross-reference with recommendations	None
Error Detection	94 Detect 94 types of errors that may cause your database to crash.	0
Improvement Suggestions	119 Find 119 types of suggestions such as unused objects and code.	0
Performance Suggestions	42 Detect 35 types of performance bottlenecks and issues.	0
Lots of Customizable Reports	YES Over 300 presentation quality reports with customizable headers. Many reports also support custom filtering.	No Only one non-customizable report per object type
Searchable Documentation	YES Our powerful treeview form makes it easy to examine the results, plus a Search feature.	No Output in report preview only without search capability
Save Documentation for Multiple Databases or Versions	YES Documentation is automatically saved so you can refer to previously generated documentation.	No Automatically deleted
Errors and Suggestions Highlights
Find references to objects, fields, or code that don't exist (renamed or deleted)	Yes	No
Find corrupt objects	Yes	No
Verify function references and parameters from forms, reports, and macros	Yes	No
Detect Unused Objects	Tables, queries, macros, classes, procedures, variables, etc.	None
Verify data types of identically named fields are consistent	Yes	No
Detect duplicate hotkeys on a form	Yes	No
Catch command buttons without code	Yes	No
Find procedures without error handling	Yes	No
Flag public procedures that should be private	Yes	No
Detect DAO and ADO data types variables not explicitly defined	Yes	No
Cross Reference Analysis
Tables used in queries, forms, reports, macros and module code	Yes	No
Fields used in tables, queries, forms and reports	Yes	No
Queries across forms, reports and modules	Yes	No
Objects called by data access pages	Yes	No
Macro calls across forms, reports and modules	Yes	No
Functions called from forms, reports, queries, and other modules	Yes	No
Module cross-references (classes, procedures, variables, labels, etc.)	Extensive	None
Diagrams (Multi-level Cross-Reference)
Application flow (see how the application works as objects, events, and procedures call each other)	Yes	No
Data flow (how data flows from tables, through queries, forms, reports, and code)	Yes	No
Object references (other objects referenced by forms, reports, and queries)	Yes	No
Module Printing
Print module text (modules, forms, reports) with line numbers	Yes	No
Print module text with a procedure index	Yes	No
Print code with loops and logic indented and with brackets	Yes	No
Specify line continuation character to easily see line breaks	Yes	No
Select fonts for code vs. comments	Yes	No
Line shading ("green bar") option	Yes	No
Module Analysis
Procedure definitions	Yes	No
Procedure call (parent-child) cross reference	Yes	No
Unused procedure detection	Yes	No
Variable cross reference	Yes	No
Unused variable detection	Yes	No
Modules without Option Explicit set	Yes	No
Procedures without error trapping code	Yes	No
Declarations to DLL procedures	Yes	No
Label cross reference	Yes	No
Cleanup (stop and debug) cross reference	Yes	No
User-defined type references	Yes	No
Enumerated type references	Yes	No
WithEvents usage	Yes	No
Class module usage	Yes	No
Visual Documentation
Form image (blueprint)	Yes	No
Report image (blueprint)	Yes	No
Annotated controls to show hidden controls	Yes	No
Output Reports
Number of reports	300+	Only one per object type
Reports by Object Type	Many	One
Reports with Sort Options	Yes	No
Select multiple reports to print at one time	Yes	No
Filter reports by object name or type	Yes	No
Customize report headers	Yes	No
Output available for future use	Yes	Always deleted
Ease Of Use
Specify properties to document	Yes	No
View documentation with forms	Yes	Only print preview
Search documentation for values	Yes	No
On-line help	Yes	No
Printed user manual	Printed, extensive, and indexed 188 pages	No
Basic Documentation
Object inventory	Yes	No
Linked table attributes	Yes	No
Relationship linked table path	Yes	No
Referential integrity settings	Yes	Partial
Query tables and joins	Yes	No
Data access pages	Yes	No
Macro arguments as text	Yes	Partial, Sometimes just numbers
Workgroup documentation of Users, Groups, Permissions, Options	Yes	Partial, Permissions only
ADP tables documented	Yes	No
ADP views documented	Yes	No
ADP stored procedures documented	Yes	No

Discover why so many Access users and developers insist on running Total Access Analyzer on their databases before the ship it to others! After all, why risk your reputation when Total Access Analyzer can catch problems before your users see them?