Product Reviews

Total Access Analyzer 2002

The standard for documenting Access databases

FMS makes quite a few useful utilities now, but this is the one that started them off in the Microsoft Access world a decade back. TA Analyzer is, quite simply, the standard for documenting Access databases and projects.

To use TA Analyzer, you open it from the Add-Ins menu, select objects (or your entire database) and tell it to get to work. It then goes off and gets as much information as it possibly can from those objects. It combines this with performance and error analysis to make suggestions about improving your database, and builds dependency diagrams to show you which objects are used where.

Particularly notable in this new addition (besides the obvious support for Access 2002 databases) is the extended list of best practices and suggestions. For example, if you've created a listbox control with its LimitToList set to No, but haven't written a NotInList event, Analyzer will flag this as a probable error (you can also decide which things to check for if you don't agree with FMS's best practices). Property listings, lots of reports, cross-references, field dictionaries, searching in the documentation...I could fill the whole review with a simple feature listing. But suffice it to say that this remains one of the most essential add-ins on the market for the serious Access developer.

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.

Featured

  • How To Enable Guest Access for Office 365

    While it's possible to give outside users access to certain content in your organization's Office 365 environment, the process of setting them up requires a few extra steps.

  • Microsoft Now Supports OpenSSH in Windows Server 2019

    Microsoft announced on Tuesday that the OpenSSH solution used for remote management is now a supported "Features on Demand" addition in both Windows 10 version 1809 and Windows Server 2019.

  • Microsoft's December Security Patches Includes Fixes for Two Active Exploits

    Microsoft ended the patch year on Tuesday with a whimper of sorts, releasing an estimated 39 security fixes in its December bundle plus one security advisory, according to a count by Trend Micro's Zero Day Initiative.

  • Microsoft Edge Browser To Get New Rendering Engine but EdgeHTML Continues

    Microsoft isn't exactly killing off its EdgeHTML rendering engine, even after declaring plans to use Chromium open source technologies in its Edge browser.

comments powered by Disqus
Most   Popular

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.