Jump:

Search:

Microsoft Access 2007 Version
is Shipping!

New X.8 Versions
available for Access
2003, 2002, and 2000!

Access 97 Version

All Access Products

Analyzer Info:

PDF Fact Sheet
(426K)

Take a Tour

Best Practices (Errors, Suggestions, and Performance Tips)

Summary List of Reports

Complete List of Reports

Finding Unused Objects and Code

FAQs

User Manual

Best Access Add-In
Rave Reviews

Why Analyzer?

for Users, Developers & Consultants

Compare with Microsoft's Documenter

Convince Your Boss

"Total Access Analyzer is an amazing product that I’ve relied on and recommended for years. It’s a huge time saver."

Sal Ricciardi Programming Writer, Microsoft Corporation

Additional Info:

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	98 Check 98 types of errors that may cause your database to crash	0
Improvement Suggestions	142 Detect 142 ways to improve your database such as finding unused objects and code	0
Performance Suggestions	45 Discover 45 ways to improve performance	0
Useful Reports	YES 350+ presentation quality reports with customizable headers. Many reports also support filtering	No. Only one non-customizable report per object type
Searchable Documentation	YES Our powerful treeview form makes it easy to examine the results. Search feature finds any string across your properties and code	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 each time
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, forms, reports, macros, classes, procedures, variables, etc.	None
Verify data types of identically named fields are consistent	Yes	No
Detect duplicate SQL in queries and form/report record sources	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	350+	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
Export one more more reports to other formats	PDF, HTML, text, RTF, Snapshot, and XPS (2007 Version)	No
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
Saved Import/Export specifications	Access 2007	No
Embedded Macro documentation, printouts, and analysis	Access 2007	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?