Total Access Analyzer

Total Access Analyzer examines all your database objects to provide extensive documentation, code analysis, object cross-reference, and diagrams with over 380 presentation-quality reports
Total Access Analyzer examines every object in a database and their relationships to each other to provide complete documentation and reporting options. It also provides extensive module analysis for improving code and uncovers critical information such as broken or missing references to objects, unused objects (tables, queries, procedures, variables etc) and inconsistent field types among identically named fields.

Features include:

• Errors, suggestions and performance tips
• Detailed code analysis
• Object, Field and VBA cross referencing
• Powerful search engine
• Results Explorer
• Presentation quality reports
• Documents all Access Objects.

Total Access Analyzer - Features

Total Access Analyzer examines every object in a database and their relationships to each other to provide complete documentation and reporting options. It also provides extensive module analysis for improving code and uncovers critical information such as broken or missing references to objects, unused objects (tables, queries, procedures, variables etc) and inconsistent field types among identically named fields.

Features include:

• Errors, Suggestions and Performance Tips: fix errors and improve databases. Detect unused tables and queries, broken references, corrupt objects, command buttons that do nothing and forms controls without default tab order. Databases are examined for improvements to the design and performance and an extensive list of recommendations is provided
• Detailed Code Analysis: all module code is examined for errors and improvement. Unused variables, unreferenced assigned variables, procedures that should be private, modules that do not require variable declarations, missing error handling, type cast omissions and unused labels
• Object, Field and VBA Cross Referencing: understand how objects are related to each other before making changes. Comprehensive cross-referencing shows where all objects, fields, procedures, functions, variables and other code objects are used throughout the entire database. The Application Flow, Data Flow and Object diagrams reveal multi-level relationships
• Powerful Search Engine: search the results for any string after generating documentation
• Exclusive Results Explorer: the generated documentation can be viewed on screen using the Documentation Explorer. It is organised in a treeview and displays information for the entire database by object type, individual objects or the same property across multiple objects
• Presentation Quality Reports: 295 reports display database details in a variety of formats and sorting options. Reports can be previewed or printed and most reports support object filtering
• Documents all Access Objects: generate information to manage every Access object and property. Summary and detailed information are available for each object and object type and reports are formatted.

Total Access Analyzer - System Requirements

• Microsoft Windows 98, NT 4, ME, 2000 or XP
• Microsoft Access 2.0, 97, 2000, 2002, 2003
• 64 MB RAM installed (128 MB recommended)
• 20 MB available hard disk space for installation.