Total Access Analyzer for Microsoft Access 97

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!

Best Access Add-in

Best Access Add-in

Best Access Add-in

Best Debugging Tool

Best Documentation Tool

Best Documentation Tool

Best Development Library

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

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

Pricing and Availability

Versions are available for Microsoft Access 97, 2000, 2002, 2003, 2007, 2010, 2013, and 2016.