Because of the differences between Microsoft Access versions and Total Access Analyzer's documentation of properties and features unique to each Access version, Total Access Analyzer is Access version specific and does not support other versions of Access. For example, Total Access Analyzer 2016 only works as an add-in in Microsoft Access 2016.
That said, Total Access Analyzer documents databases in any format that is supported by its Access version. For example, Total Access Analyzer 2003 documents 2000 and 2002-2003 databases provided that the database is opened in Access 2003.
Similarly, Total Access Analyzer 2016 document databases that are in Access 2000 format, Access 2002-2003 format, and ACCDBs created in Access 2007, 2010, 2013 or 2016. Note that Access Data Projects (ADPs) are not supported in Access 2013 or later, so if you need to document ADPs, the Access 2010 version is the last one that supports it.
The following versions of Total Access Analyzer are available:
All versions of Total Access Analyzer can be on the same machine provided that they are installed in separate folders. Owners of an earlier version of the product are eligible for discounted upgrade prices when purchasing a newer version.
Check the Product Compatibility Chart for version information for all of our products.
For information on the history of Access versions, visit our Microsoft Access Version Releases, Service Packs, Hotfixes, and Updates History page.
Download the Trial Version to try Total Access Analyzer before you buy it. The Trial Version shows how Total Access Analyzer works but does not analyze your database. It demonstrates documentation of the Northwind database so you can view the results and print the reports.
All FMS products come with a 30-day money back guarantee, so you can buy with confidence!
Total Access Analyzer does not make changes to your database. Due to the nature of the issues detected, many items require the database developer or administrator to make decisions about what should be changed, and the impact the changes have on the overall application.
However, Total Access Analyzer has many tools that make it easy for you to make the desired database changes. For example, the Documentation Explorer has a feature that lets you jump right to the object that triggers an error or other issue. Additionally, several reports are available that show details about what should be changed and how to change it.
For modifications to your VBA code, check out our Total Visual CodeTools product. It has a Code Cleanup feature to add error handling to every procedure that lacks it, insert standard commenting structures, standardize indentations, rename variables to a naming convention you specify, and much more.
Yes and No. Total Access Analyzer runs in Microsoft Access as an add-in and examines your currently open Access database. If your database has linked tables to SQL Server or any other backend database (including Microsoft Access), it documents those tables and generates lists of table properties, field names, data types, and other properties.
It cannot document objects in the backend database that are not connected from your current Access database. This would include things like SQL Server stored procedures, triggers, diagrams, tables and views that aren't linked, etc.
Documentation is also based on the permissions you have to the backend data source.
Yes. Total Access Analyzer (version 2000 to 2010) supports documentation and analysis of Access ADPs. The documentation is for the Access objects on the ADP and what it can see in SQL Server, but not all the backend features of SQL Server. Support for ADPs was discontinued with Microsoft Access 2013.
Because of the many differences between MDB (includes ACCDBs) and ADPs, there are significant differences with the documentation Total Access Analyzer generates and the way it behaves.
Certain object types are similar between MDBs and ADPs. For instance, forms, reports, data access pages, macros, modules, command bars, and import/export specifications are essentially the same with similar documentation.
However, some objects only exist in one and not the other. For instance, queries only exist in MDBs, while ADPs have views, database diagrams, and stored procedures. Total Access Analyzer generates the appropriate documentation for all of these objects.
Both MDBs and ADPs have tables, but they are different. MDBs can link to tables or have tables stored within the MDB itself. ADPs only link to tables that exist on the server. The documentation of the tables is also slightly different. Fields in MDBs are called Columns in ADPs. ADP tables also have Keys and Triggers. Again, these are documented based on the database type.
Please refer to the user guide or help file (specifically the sections MDB vs. ADP Documentation and Documentation Limitations for ADPs) for details about documenting ADPs.
Total Access Analyzer is a Microsoft Access Add-in program.
Total Access Analyzer does not require Administrator rights to be installed for the current user. Total Access Analyzer does require Administrator rights if installed for machine. This is controlled by Windows permissions.
Visit this page for details about how Total Access Analyzer detects unused objects and code in Access databases. There are two ways to see this information:
Like all listings of unused objects, you need to be careful before deleting them because they may be used in ways Total Access Analyzer cannot detect (for instance interactive use or a table driven system with object names stored in tables). Look under Limitations in the help file to understand what Total Access Analyzer can and cannot detect.
In the Access 2007 version (or later), Total Access Analyzer offers the ability to export one or more reports in a variety of formats to a folder you specify. Formats include Adobe PDF, HTML, Snapshot, Text, RTF, or XPS:
This feature was added in the X.8 version of Total Access Analyzer for Access 2003, 2002, and 2000, With the X.8 version, you can export reports to HTML, Snapshot, text, and RTF.
If you are using a version that is prior to X.8 and do not upgrade, saving a Total Access Analyzer report in a different format is something that can be done, but does not always work for all reports. The ways to do this are below:
These methods do not always work properly and some information may be missing or formatted incorrectly for how you want to view it. The formatting is due to the way that Microsoft handles the output of the fields or controls it finds. We have no control over this formatting or the output functionality since this is Microsoft Access functionality for outputting reports and not our own.
If there are form properties or queries (record-sources and row-sources) that call procedures, Total Access Analyzer checks that and verifies those procedures exist and are passed the right number of parameters.
Module code that calls procedures that donít exist are caught if you try to compile the code.
If the database does not compile, undefined procedures are reported under our error code 6001. We flag procedures called, but not defined.
This occurs if Total Access Analyzer is not properly installed and/or the registry setting for Microsoft Access add-ins was modified. Possible causes for this are:
Total Access Analyzer is installed by using its setup.exe file:
This VBA error may occur when you launch Total Access Analyzer. Unfortunately, due to Access flagging a VBA error, our code cannot run to properly trap and handle the problem.
This is most likely due to your version of Access not having the latest service pack installed. In general, we try to create versions of our products that work with all Microsoft Access releases for a version. Unfortunately, that's not always possible since Microsoft sometimes breaks compatibility with their updates, and some of the updates fix problems to allow our programs (and yours) to work properly.
If you have these Microsoft Access versions, be sure you have at least these service packs installed:
If you don't have these versions, your Windows Update feature can download and install them for you.
If you have the latest versions installed, and still encounter this problem, our program may be corrupt and you should uninstall and reinstall it. Make sure the files in the Total Access Analyzer folder are all deleted before reinstalling.
This error is due to a problem with the Windows treeview control and occurs in legacy versions of Total Access Analyzer. A new treeview control was used in Total Access Analyzer 2013 and 2016, so this error does not occur in those versions. This was also addressed with updates for the Access 2010 and 2007 versions when the 2013 version was released.
However, for older versions, this error may occur when you try to view the documentation results in the Explorer form:
Error 459 - Object or class does not support the set of events, Procedure clsFrmExplorer_TAA.InitForm
Our form uses the Microsoft Common Control for the treeview, which was reliable for over a decade. In August 2012, Microsoft released a security patch that caused this crash in existing versions of Total Access Analyzer and many other Windows programs in .NET, VB6, Access, etc.
Microsoft acknowledged this problem. They even provide a workaround in a Knowledgebase article. Unfortunately, their suggestion does not work. For a reliable solution, read our paper: Fixing the Microsoft Windows Common Control Library (MSCOMCTL.OCX) Security Update.
Note that this does not affect your documentation. Once you fix this, you will be able to view your results without having to recreate it.
The first step when you receive any error is to make sure you're using the latest version of Total Access Analyzer. Check the Updates Page and make sure you have the latest build.
If you using the latest update and are still encountering an error, it may be caused by corruption or broken references in your database. This problem can manifest itself as one of the following errors:
To resolve these issues, follow the steps to decompile and recompile your database. This often fixes mysterious corruption issues related to VBA code.
If that fails, the Total Access Analyzer program may be corrupt. Reinstall the program:
If after applying the latest update you are still encountering errors (for instance, you can't even document the Northwind database), then please contact us so that we can be of further assistance.
You may see this error when running the Update Wizard:
Update Wizard not initialized properly
This error occurs when you run the Update Wizard by double clicking "Update.exe" instead of launching it from the Windows Programs Menu shortcut.
This is because the update.exe file requires parameters to run and return the correct information. In order to determine if there is an update available for this product, please run the update wizard program from the Windows Programs menu:
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
Sal Ricciardi, Programming Writer, Microsoft Corporation