"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
More Reviews
|
|
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!
|
I could summarize Total Access Analyzer in one sentence:
"You have to have this program!"
Thomas Wagner
Access Advisor Product Review |
|
 |
 |
 |
|
|
 |
|
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
Pricing and Availability
Versions are available for Access 2.0, 97, 2000, 2002,
2003, 2007, and 2010.
|
|
All Our Microsoft Access Products
Single
