New features for the X.7 versions:
General
- During module documentation, the VBA IDE no longer flashes on the screen.
- Faster performance
- All reported issues and errors for previous versions are resolved.
- When selecting tables for documentation, a new feature allows you to filter the table list by System tables or Regular tables.
- The documentation is optimised to run more efficiently than ever.
- A new "Suggestion Box" link on the Main Menu allows you to send product suggestions directly to our development team.
- Documents only the Access options that apply to the database type: MDB or ADP.
Documentation Enhancements
- Documentation can run on databases that are not complied, although module cross referencing may be incomplete for these databases.
- Blueprint reports for form and report layouts are now available for databases that are in Access 2002-2003 format. Previously, an Access/Jet bug prevented us form generating these blueprint reports.
- Improved documentation of form and report controls, and their associated labels.
- Documentation of Hyperlink and Subhyperlink addresses is enhanced.
- Issue Filter form displays only issues that exist in the current documentation results.
- Improved documentation of CommandBar controls.
- After documentation is complete, the Documentation Summary form displays a count of issues by object type.
New Reports
- Two new reports are available to show Relationships and support filtering.
- Two new reports show controls with their associated labels.
- Two new reports show table field lists in Landscape mode to better display long table names, field names, and field descriptions.
- Module XRef reports with Functions now displays control and property information.
- The Blueprint Detail report displays the source object name for subform/subreport controls.
- Two new reports for Table Fields, Sorted by Data Type. One with the summary of fields by data type and size, and the other showing the details of fields of every data type and size.
New Error Detection
- Report references to broken hyperlinks.
New Suggestions
- Procedure names that conflict with reserved words.
- Combo boxes on tables and forms that display the default number of 8 rows. Displaying more rows allows users to see more items at one time.
- Suggestions for improving primary key fields:
- Tables with primary keys not in the first set of fields.
- Tables with more than one field as their primary key.
- Tables that use non-numeric fields as their primary key.
- For MDBs, tables that do not use autonumber field as their primary key.
- For ADPs, tables that do not use Identity fields as their primary key.
- Modules without Option Compare specified
New Performance Tips
- Form and report RecordSources that should be a saved query.
- Action queries that maintain a transaction log.
- Tables linked to old Access database formats.
- The use of the slow Domain functions in forms, macros, and reports. Previously, it only documented their use in modules and queries.
Enhancement of Existing Issues
- Invisible labels and labels with hyperlinks no longer trigger the suggestion to be associated with a control.
- Suggestions regarding conflicts with Jet and SQL Server Tables are no longer detected for system tables.
- Improved detection of unused Enums and Enum elements.
Documentation Explorer Enhancements
- While viewing issues in the Documentation Explorer, new shortcut (Alt+D) allows you to quickly view the object in design view. This makes it even easier to investigate and fix the issues that Total Access Analyzer finds
- Boolean property values are displayed as Yes/No instead of as -1/0.
- Macros can be opened in design view in international versions of Access.
Reporting Enhancements
- On the Report Options form, a new feature allows you to reset all options to their default values.
- The Hyperlink report (under Object XRef) now contains a check box to show code references to a hyperlink address that's a variable or constant.
Comprehensive Database Analysis
Total Access Analyzer performs detailed analysis of your Access database to generate complete documentation of all objects and code. It examines your entire database to reveal complex relationships among objects, hidden problems, and even unused objects. Take control of your databases by understanding how they work. Total Access Analyzer not only generates cross-references between your objects, it also creates diagrams of your application and data flow to show multi-level relationships. Great for getting up-to-speed on databases created by others.
Create Better Access Applications
Total Access Analyzer helps you apply the 'Best Practices' principles that has been learned at FMS. Perform the same analysis on your databases to see what you can improve. For instance, eliminate potential data loss with the field consistency analysis that ensures identically named fields across tables are defined consistently. Find forms with duplicate hotkey letters, reports without a NoData event, unused objects and code, procedures that should be private, and much more.
Simplify Your Development Efforts
As your databases grow in complexity, they becomes harder and harder to understand. Total Access Analyzer generates the information you need to maintain control and efficiency. From simple table structure lists, to field dictionaries (for a field name, see every table it is defined), to property listings, object cross-reference, flow diagrams, and code printouts, Total Access Analyzer gives you the data and reports you need to manage your systems.
Don't Ship Without Running It
Total Access Analyzer detects errors that can cause your application to crash. For instance, you may have a form that references a table or field that was renamed. That form will crash when your user opens it. Total Access Analyzer catches these errors before you ship. Think of the time and embarrassment you'll save! Discover why so many organizations run Total Access Analyzer as part of their final quality assurance check before deploying their databases.
Sophisticated analysis detects over 100 types of errors and ways to improve your database. Find bad field and object references, unused queries and code, and much more. Use the powerful diagrams to understand your application and data flow.
All output is stored in an Access database. You can view and search the documentation using FMS's sophisticated multi-table forms, print the output using any of the program's 225+ reports, or perform your own analysis.
Variants are available for Access 2.0, Access 97 or Access 2000.
Total Access Analyzer is also available as part of:
- Total Access Ultimate Suite
- Total Access Developer Suite
- Total Access Enterprise Suite
A 30-day Trial version is available for download from Grey Matter's website. This demo program lets you explore how Total Access Analyzer works and the output it generates. It includes documentation of the sample database SOLUTION.MDB included with Access. With this demo, you can see the large variety of results generated by Total Access Analyzer, including view forms and 225+ reports. Reports include formatted module printouts, table structure reports, application flow diagrams, field type analysis, form and report blueprints, and many other reports to help you take control of your databases.
Total Access Analyzer is licensed on a per developer basis. Each developer who runs the program must have a license.