Released: Mar 10, 2009
Updates in this release
Updates for 2007
Total Access Analyzer General Improvements
- 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 optimized to run more efficiently than ever
- A new "Suggestion Box" link on the Main Menu allows you to send product suggestions directly to the FMS development team
- Documents only the Access options that apply to the database type: MDB or ADP
Documentation Enhancements in Total Access Analyzer
- 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 available in Total Access Analyzer
- 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
Total Access Analyzer includes now 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
Reporting Enhancements in Total Access Analyzer
- 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
