Our friend Alison Balter is a popular speaker, author, and trainer in the Microsoft Access community. She's been a user and fan of our products for many years. In her Mastering Office Access 2003 book, she wrote a whole chapter on ThirdParty Tools That Can Help You Get Your Job Done Effectively, where she covered many of our Access related products:
Total Access Analyzer is the world's most popular Access product. We recently shipped the Access 2007 version, and are now pleased to provide versions X.8 for Microsoft Access 2003, 2002, and 2000. The new versions are a significant upgrade and let you create and maintain Access solutions better than ever. Enhancements include the detection of new suggestions and performance tips including duplicate SQL string analysis across queries, record sources, and row sources. There's also a redesigned user interface, new reports, one click opening of the current object in design mode when viewing documentation and search results, Vista support, and much more. Click here for a complete list of new features in version X.8. We hope you like the results!
If you're like most Microsoft Access users and developers, you've created databases with lots of objects. Over time, it's easy to lose track of which objects are still needed. A temporary query or report becomes permanent because you're not sure if it's being used by other objects. Same with macros and VBA code. The annoying thing is that you may waste time maintaining objects and code that's not even being used. I've written a detailed article about the challenges of finding unused objects (you have to first determine where all objects are referenced before identifying unused ones) and one of the main benefits of using Total Access Analyzer. http://www.fmsinc.com/MicrosoftAccess/UnusedObjects/FindingDeleting.html