Total Access Analyzer 2019

Report, View Explorer and Quick Documentation enhancements.
August 28, 2019 - 9:01
New Version

Features

  • Ribbon Documentation - Three new reports are available under Database (Access 2007 and above):
    • Ribbons List
    • Ribbons XML (Landscape)
    • Ribbons XML (Portrait)
  • Data Macro Analysis - Total Access Analyzer now parses data macro code to document what they do and the objects they use. Data macros now appear on the View Explorer in a folder under its table with each data macro listed. Three new reports are available (Access 2010 and above):
    • Table Data Macro Events
    • Table Data Macro Events and Lines
    • Table Data Macro References, Sorted by Table Name
  • SQL Cross-Reference and Validation of Subform References - The SQL parser detects more references to tables, queries, fields and controls across your database objects and table alisases. References to fields or controls in subforms are also analyzed to make sure they exist.
  • New Errors and Suggestions - These issues are now detected:
    • Report View with Section Format Event, for reports that allow report view and have a Format event which may not run in Report View. This can result in displaying confidential or bad data.
    • Ribbon Unused
    • Form References to Undefined Ribbons
    • Report References to Undefined Ribbons
    • Ribbon References to Undefined Macros/Functions
    • Data Macro Could Not Be Analyzed
    • Improved resolution of form and report control references to fields in subforms/subreports, expressions and undocumented objects
    • ReplicationID (GUID) fields are no longer flagged as invalid for primary keys or needing to be AutoNumber
    • Improved unused variable analysis
    • Previous suggestions to convert VBA string command to explicit string functions (e.g Mid$ instead of Mid) are no longer suggested.
  • Report Enhancements
    • Report List has Report Name Filter - The report list for the Main Documentation and Quick Doc, adds a text filter for report name. Type a few letters to narrow down the list of reports: The Category column is also enabled so you can select and filter on it.
    • New Reports for Queries with Form Control, VBA and Procedure References - Added two new reports for queries that reference forms and control:
      • Queries with Form Control References
      • Queries with Form References
      • When migrating Access databases to other platforms like SQL Server, it’s helpful to know which queries have dependencies on VBA functions and your own procedures. Total Access Analyzer has four new reports to show which queries have these dependencies:
      • Queries with Procedures
      • Queries with VBA Functions, Count
      • Queries with VBA Functions, Sorted by Query
      • Queries with VBA Functions, Sorted by Function
    • New Reports for Form and Report ControlSource Property - Four new reports are available to show the ControlSource of controls on forms and reports. This makes it easy to see direct field references and expressions (calculated fields) placed on your forms and reports:
      • Form ControlSource Values
      • Form ControlSource Expressions
      • Report ControlSource Values
      • Report ControlSource Expressions
    • New Reports for Form Combo Box/List Box and Validation - Three new reports are available to see the properties associated with Combo Box and List Box controls, and controls with validation properties:
      • Form Control Type Combo Box and List Box Properties
      • Form Control Validation Properties
      • Report Control Type Combo Box and List Box Properties
    • New Reports for Object XREF - Two new reports show where controls are referenced from other objects. For instance, a form may reference a control in subform, or a report referencing a value from a currently opened form’s control:
      • Control References from Forms and Reports, Sorted by Calling Object
      • Control References from Forms and Reports, Sorted by Referenced Control
      • Additionally, it captures module variables that reference other object like opening a form or recordset:
      • Object References by Variable, Sorted by Calling Objects
    • Many Reports Updated to Support Report View Filtering - Total Access Analyzer reports can be displayed in Print Preview or Report View. For Report View, you can filter the data while you view it. Some of the reports used expressions to combine fields (e.g. Object Type and Object Name) which prevented the ability to filter them. Where possible, the object type and object name are separated into their own controls so they can be filtered in Report View.
    • Report Sets can be Saved in a New Location - Report sets let you define multiple reports in a group for easy retrieval and printing. By default, these settings are saved in the TAA_Rep.mda database in the user’s Total Access Analyzer’s folder. You can now point to a database on a shared network drive so multiple users and machines can reference the same set of reports.
  • View Explorer Enhancements
    • In addition to Ribbons and Data Macros, the View Explorer supports resizing better and offers more features:
    • Datasheet Column Widths are Saved - While viewing the documentation results, if you adjust column widths, the settings are saved and applied the next time you view it. Your columns widths are similarly preserved when viewing the Search results.
    • Filter for Errors, Suggestions and Performance Tips Shows Reviewed Count - When viewing the list of issues (on the Errors, Suggestions and Performance tabs), you can check off the items that are Reviewed to focus on the remaining ones. The status is maintained if you document the database again. There is a Filter button to select the list by issue type. The filter shows the number of instances discovered for each type. It now shows the number you’ve reviewed and not reviewed to make it easier to select.
    • Relationship folder has a Relationship XREF tab showing joined tables and fields
    • Command Bars, Property Slices tab adds a Control option to show a property value across all the controls
  • Quick Documentation Enhancements
    • Database now includes an overview of table and query objects along with container documentation
    • Workgroup security is now a separate item
    • When documentation is finished, the elapsed time is shown
  • About Box has Check for Updates
    • A new [Check for Updates] button contacts the website to see if the current version of Total Access Analyzer is the latest version. You may be eligible for a free update.
  • Revised User Manual and Help File
    • The user manual and help file are updated.
  • Improved User Interface
    • New icons, larger fonts, and larger forms are used where appropriate to provide a more modern and readable user experience.
Report List Name Filter

Total Access Analyzer

Document and analyze your Access databases.

Got a Question?

Live Chat with our FMS licensing specialists now.