The most powerful Microsoft Access database documentation and analysis program is now available for Microsoft Access 2013.
Total Access Analyzer helps you know:
Total Access Analyzer supports all the features of MS Access 2013 with additional enhancements from the 2010 version to extend its functionality and improve its use based on our experiences and customer feedback.
Main Form for Total Access Analyzer 2013
We've made many enhancements since the previous version for Microsoft Access 2010:
Total Access Analyzer 2013 includes a 32 bit and a 64-bit version of its add-in to support both versions of Microsoft Access 2013. The setup program automatically detects the Access 2013 version you've installed and installs the appropriate one. It supports any operating system (32 and 64 bit) that Access 2013 supports.
Total Access Analyzer supports all the database types Microsoft Access 2013 uses including:
This means you can use Total Access Analyzer 2013 with Microsoft Access 2013 to document and analyze databases created by older versions of MS Access.
Note that Access 2013 no longer supports Access Data Projects (ADP) linked to SQL Server, so Total Access Analyzer 2013 cannot support them either.
On forms and reports, controls may have conditional formatting to use colors and relative size for different values. Total Access Analyzer documents those settings and performs cross-reference analysis to determine if fields, code and other references are valid. These new reports are available:
Here's more information on Conditional Formatting Documentation.
Total Access Analyzer documents the navigation controls and buttons. References to subforms are documented and cross-referenced for validation. Additionally, an error and two suggestions are offered:
A navigation control has a navigation button that does not have any events and its NavigationTargetName property is not defined. This means if the user clicks on the button, the navigation subform is not updated and nothing happens.
A navigation control button doesn't have a caption or picture, so it's just blank.
Display a hyperlink hand rather than the default mouse arrow when the cursor is over the button. This provides a user experience similar to a web browser. Set the button's Cursor On Hover property to Hyperlink Hand to get this feature.
Documentation was enhanced to:
New reports are available to see, by control type for forms and reports, how many and where they are used in your project. The new reports include:
For the new control types introduced in Access 2010 (Empty Cell, Navigation Control, Web Browser Control)
For more information, visit Control Type Reports.
Total Access Analyzer performs module analysis and cross-referencing to identify invalid procedure calls. If your database calls functions stored in a library, those functions are not being detected and procedure calls to them are incorrectly flagged as undefined.
Total Access Analyzer cannot detect the procedures in your referenced library databases. However, if you create a table in your database listing the procedure names from your library or libraries, Total Access Analyzer will avoid flagging those procedure calls as undefined.
Simply create a table name usysTAnalyzerLibraryProcs in your database with two text fields: Procedure and Library. Fill the table with the procedure names you call. The library value isn’t required, but provided for easier tracking. Total Access Analyzer will check the list to avoid identifying those procedures as undefined.
Over the years, from customer feedback and as we encounter mistakes in our own work, when possible, we add their detection to Total Access Analyzer. This version includes three new Best Practices:
DECLARE statements let you use procedures defined in DLL files and Windows API commands. Procedures defined in DECLARE statements that are not called are flagged as unused.
Parameters shouldn’t be the same name as the property or procedure name since it creates confusion when referencing it.
Previously, all of these unused definitions were categorized into one Unused Variables group. They are now separated into three separate issues so you can manage them differently. Unused Parameters are particularly important to address because the calling procedure may be expecting different behavior from the procedure based on that parameter, but it’s completely ignored.
The VBA module parser for the 2010 version added support for compiler conditionals in the declarations section or procedures as defined in #IF...#ELSE…#END IF statements. This is particularly common when using the VBA7 constant to manage 32 versus 64 bit code:
#If VBA7 Then < 64 bit specific code > #Else < 32 bit specific code > #End If
The VBA parser in Total Access Analyzer 2013 supports entire procedures defined by compiler conditionals to avoid triggering duplicate procedure definition issues. The duplicate procedures should be paired together:
#If VBA7 Then Sub ProcName() ... End Sub #Else Sub ProcName() ... End Sub #End If
Conditional compilers are also considered when determining unused code.
A search bar, similar to what's available on the Navigation Pane, is added to the places where you select objects.
This simplifies the filtering of the list of objects by name.
The list of documented databases now shows when each database documentation process started and how long it took:
In addition to the report listing the databases by name, two new reports are available:
For the reports that show issues, you can specify a filter to limit which issues are included. The Errors, Suggestions, and Performance tabs now show the count for each issue to make it easier to decide which issues to include:
The Count Field is Added to the Report Filter for Issues
The hierarchical treeview is used in the View Explorer and Diagrams. A new treeview interface is provided with more modern graphical icons and font, more responsive expand and collapse behavior in the diagrams, and support for 32 and 64-bit versions of Microsoft Access. It also eliminates the dependency on the treeview in the Microsoft Common Control which has experienced Microsoft update issues that caused it to fail.
When viewing module results, the Module Tab now shows the entire module rather than separate records for each procedure
When viewing module results, you can press the Design icon to open the module editor at the current procedure. This feature is enhanced to better handle property Get, Let, and Set definitions, and to move to the first line of the procedure (after any comment lines) and highlight it.
With higher and higher resolution monitors, larger fonts are used throughout the program to make it easier to read.
Updated manual and help file with detailed documentation of how the program works and how to best use it.
Due to the differences within each version of Microsoft Access, there is a separate version of Total Access Analyzer for each version of Access.
Total Access Analyzer Pricing
by Microsoft Access Version
|Microsoft Access Version|
|Single||$299||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Seat||$899||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
Upgrade Between Access Versions
|Single||$199||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||N/A|
|5-Seat||$599||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
Update to the Latest Version within the Same Version
|Update 14.5||Update 12.95||Update 11.95||Update X.8 Features|
|Single||$149||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
|5-Seat||$449||Buy Now||Buy Now||Buy Now||Buy Now||Buy Now|
Premium Support Subscription
Also available as part of
Total Access Ultimate Suite
Total Access Developer Suite
|Total Access Analyzer is licensed on a per user basis.
Each user who runs the program must have a license.
Read the License Agreement for details.
With the release of the MS Access 2013 version, we also created updates for earlier versions of Access:
Benefit from the enhancement even if you haven't migrated to Access 2013. Existing customers can upgrade within the version at a discounted price.
Version 15.0 for
Microsoft Access 2013
Version 14.5 for
Microsoft Access 2010
Version 12.95 for
Microsoft Access 2007
Version 11.95 for
Microsoft Access 2003
Version 10.8 and 9.8 for Access 2002 and 2000