Total Access Analyzer
Document, Analyze, and Detect Errors in your Databases

Discover why Total Access Analyzer is the most popular Microsoft Access add-in and the winner of EVERY Best Access Add-in award since 1994! Product Highlights Feature Summary Pricing and Availability Product Fact Sheet Rave Reviews Available Reports Licensing Information Download the Trial Version

I could summarize Total Access Analyzer in one sentence: "You have to have this program!" Thomas Wagner, Access Advisor Product Review

See the Current Version!  Click Here

Best Access Add-in	Best Access Add-in	Best Access Add-in	Best Debugging Tool	Best Documentation Tool	Best Documentation Tool	Best Development Library

Product Highlights

Total Access Analyzer helps you create Access databases with more control and fewer errors. 

Total Access Analyzer is the only program that analyzes all the objects in your database to determine how it works, and reveal links and potential problems. Unlike the built-in Access documenter that only looks at individual objects, Total Access Analyzer looks at all the objects. That's the only way to tell everywhere an object is used, objects and code that aren't used (e.g. queries, procedures, and variables you are afraid to delete), references to objects and fields that no longer exist, and many other potential problems.

Why you should get Total Access Analyzer

• Catch errors before you distribute your Access database.
• Total Access Analyzer catches runtime errors such as references to missing objects or fields, corrupt objects, invalid table links, objects calling procedures with the wrong number of parameters, etc. Over 100 types of errors, suggestions, and performance tips are offered. Why let your users or clients crash on bug Total Access Analyzer can automatically detect?
• Taking over someone else's database or trying to understand your own database?
  Not sure how a database works? Total Access Analyzer gives you the detailed and summary information you need! Generate table/field listings, object cross-reference showing where each object is used, application flow diagrams, data flow diagrams, object diagrams, formatted bracketed module code printouts, and much more. 
• Get rid of unused objects and code.
  Do you have queries or code you're afraid to delete because you're not sure if they are used? Let Total Access Analyzer find your unused tables, queries, macros, sub-macros, forms, reports, procedures, variables, constants, and user defined types. Cleanup your database to make it faster and easier to maintain.
• Make sure your fields are consistent across all your tables.
  Are you sure the same field has the same type across all your tables?  Is the same numeric field sometimes an integer, long integer, and/or double? Are your text fields the same length? Total Access Analyzer catches these inconsistencies so you can quickly resolve them.
• Improve your module code.
  Enhance performance and make your application more robust by finding modules without Option Explicit, procedures without error handling, procedures that should be private, variable scope conflicts, unnecessary debugging code, type cast omissions, etc.
• Generate printed documentation of your Access database.
  Creating archival documentation of your database is a critical part of professional system development. Total Access Analyzer includes over 225 professional quality reports covering all aspects of your database. For many consultants who charge their clients for technical documentation, Total Access Analyzer pays for itself many times over. Impress your clients and bosses with extensive documentation showing the work you've done!

Feature Summary

Total Access Analyzer incorporates our extensive experience in building complex Access databases so you can too! Total Access Analyzer lets you deploy Access databases that are more robust and error-free than ever before. There are even performance tips to let you build faster applications. Here are some of its highlights:

• Extensive documentation of every object in your database
• Extensive analysis showing everywhere each object is used (object cross-reference)
• Powerful module printouts with line numbers and bracketed source code loops
• Three diagram reports showing Application Flow, Object Flow, and Data Flow
• Detects over 100 types of errors and suggestions to improve your database
• Finds unused objects: queries, macros, and code (procedures, variables, etc.)
• Powerful Field Analysis to ensure your field names, types, and sizes are consistent
• Relationship Window printouts
• Powerful hierarchical tree view browser to see the results
• Over 225 customizable reports
• Runs from the Add-ins menu

Versions are available for Access 2.0, 97, 2000, 2002, and 2003.

Pricing and Availability

Total Access Analyzer Pricing by Microsoft Access Version
Licenses	Price	2007	2003	2002	2000	97
Single	$299
5-Seat	$899
Upgrade Between Access Versions
Single	$199					CALL
5-Seat	$599					CALL
Upgrade to version X.8 within the Same Version
New Version X.8 Features
Single	$99	N/A				N/A
5-Seat	$299	N/A				N/A
Premium Support Subscription
Single	$299
5 Seat	$999
More Information
Also Available as part of:
Total Access Ultimate Suite Total Access Developer Suite
Runtime/Redistributable Version
Not Applicable
Licensing Information
Total Access Analyzer is licensed on a per developer basis. Each developer who runs the program must have a license. Read the License Agreement for details.

Due to instability problems in Access 95 (version 7.0), we are unable to create a version of Total Access Analyzer for it. Access 95 users should get the Access 97 version of Total Access Analyzer, convert their database to Access 97, run the program, then implement the fixes in the Access 95 database.