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

  • Microsoft Previews New App Reporting and Consent Tools in Azure AD

    Microsoft last week described a few Azure Active Directory improvements for organizations wanting to connect their applications to Microsoft's identity and access service.

  • Free Software Foundation Asks Microsoft To Release Windows 7 Code

    The Free Software Foundation this week announced that it has established a petition demanding that Microsoft release its proprietary Windows 7 code as free software.

  • Managing Multiple Remote Connections in One Place with mRemoteNG

    If you're juggling multiple remote connections daily, this is the utility for you. Brien walks through the steps to use mRemoteNG, from installation to deployment.

  • Microsoft Unveils Plan To Push Bing to Office 365 ProPlus Users

    Microsoft on Tuesday unveiled plans to deliver an extension that will change the default search engine to Bing in both Google Chrome and Mozilla Firefox browsers for Office 365 ProPlus subscribers.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.