New Features of Total Access Analyzer for Microsoft Access 2007, Version 12.0

Main screen shows the context of the currently documented database and your ability to view, search, and print reports for it.

You can also open it without closing your current objects.

Individual or multiple reports can be exported to formats such as Adobe PDF, HTML, Snapshot, Text, RTF, or XPS to a folder you specify:

Reports can be sent to the new Report View which supports your ability to filter the results interactively

There are 353 professional quality reports. Here are some of the 24 new reports:

• New Access Options reports (completely different from the Access 2003 options under Tools, Options)
• Import Export Specifications
• Embedded macro listings
• Objects embedded macros cross-reference
• TempVars assignments and cross-reference
• Objects with Identical SQL and RecordSource
• Unused forms, reports, and code
• Enhanced Database Summary reports

After documentation, reports without data are not listed to make it easy to see what's available.

• One click loading of the current object in design view. Whether it's from the Diagrams, XREF, Errors, Suggestions, or Performance Tips tabs, you can press Alt+D and put it in design mode to immediately review the object or module for the changes to make.
• Significantly improved performance when viewing results, and looking at detailed property lists for one object or across all objects of one type
• Improved maximized mode with splitter bar between panes

Total Access Analyzer detects 285 specific types of errors, suggestions, and performance tips for your database. Here are some new ones

• Eliminate/Consolidate duplicate queries: Identical SQL Analysis to determine if the same SQL string is used across multiple queries, or the record source and row source of forms and reports
• Check and recommend the settings of the new Access options like tabbed view, Search Bar, datasheet design change option, etc.
• Forms with navigation bars should have a custom Navigation Caption
• Command Buttons should show the Hyperlink Hand on mouse hover.
• Datasheet and continuous forms should take advantage of the new alternating background color option
• Unused forms and reports
• Module analysis:
  • Use of old constants from pre-Access 97 syntax
  • Procedures with exits in the middle of its body which could bypass cleanup code at the end of the procedure
• Date fields with input masks (the Format property should handle this)
• Forms with the Moveable property set to No
• New Access option for database picture property storage to reduce database size
• Forms with unnecessary scroll bars

Here's a complete list of Best Practices detected by Total Access Analyzer.

Search lets you find any string among the documented objects, macros, and modules. While viewing the search results, you can put the object in the current record into design mode by pressing Alt+D or the Design button:

• Detects table and query references from the open command of ADODB recordsets and adds this to the Object XREF views and reports
• Detects explicit control references from code (e.g. Form_MyForm.txtValue) with new Object XREF reports
• Documents the TempVars object definition and usage