Microsoft Access Database Documentation and Analysis
300 Ways To Create Better Microsoft Access Applications
FMS is pleased to announce Total Access Analyzer 2010 is now shipping with
support for both the 32 and 64 bit versions of Microsoft Access 2010. Total Access Analyzer is the world's most popular Microsoft Access
product winning every Best Access Add-in Award since 1994. This is the tenth
major release of Total Access Analyzer since its debut in 1992.
Comprehensive Microsoft Access Database Documentation
Total Access Analyzer examines each Microsoft Access database to provide
detailed documentation of individual objects and their relationships to each
other. Comprehensive code analysis of VBA module code and macros is also
performed. A powerful search features lets you find any string across all the
properties, macros, and modules. Over 375 presentation quality reports are
available with a wide variety of customization, sorting, and filtering
Avoid Crashes Before You Ship
The popularity of Total Access Analyzer is its ability to help Access users
and developers improve their applications, avoid errors that can cause their
solutions to crash, and learn best practices to increase their skills. By using
Total Access Analyzer to take over an existing application, during
development, and before deployment as part of one's quality assurance process,
developers can avoid embarrassing mistakes and improve consistency and
Most importantly, Total Access Analyzer detects 300 ways to avoid errors,
apply best practices, and improve performance. By leveraging our years of
experience and customer feedback, FMS has created the most powerful system for
diagnosing Microsoft Access applications. For instance, Total Access Analyzer
can detect broken references to tables, fields, forms, reports, macros, and VBA
code that will cause the database to crash as soon as they're encountered. It
finds unused objects (tables, queries, forms, and reports), macros, classes,
procedures, variables, constants, etc. to help developers get rid of unnecessary
and old work.
Advanced analysis is also performed to detect inconsistent field definitions
across tables, duplicate SQL definitions, macro command problems, etc.
Multi-level object and code relationships are presented with three advanced
hierarchical diagrams showing application flow, data flow, and object
Microsoft Access users, developers, and consultants of all levels rely on
Total Access Analyzer to deliver great solutions. "Total Access Analyzer is an
amazing product that I’ve relied on and recommended for years," said Sal
Ricciardi Programming Writer for Microsoft Corporation. "It’s a huge time
Total Access Analyzer 2010 adds many enhancements in addition to supporting
both 32 and 64 bit versions of Microsoft Access 2010. Its VBA module code parser
now supports the conditional compiler syntax (e.g. #If VBA7 Then) that's common
for supporting 32 and 64 bit environments. There's advanced macro documentation
and analysis that includes a "macro compiler" to validate if macro commands have
the proper number of parameters. Improved views and reports simplify the review
and printouts of macro lines scattered in embedded macros across the forms and
reports. New temporary variable analysis documents and detects undefined and
unused TempVars set by macros and modules. A variety of other new suggestions
were added to detect timer event inconsistencies, query performance enhancement
opportunities, and reserved word conflicts with the upcoming SQL Server 2012.
With all the new features, Total Access Analyzer remains the most powerful
diagnostic tool for Microsoft Access databases.
"Total Access Analyzer provides the comprehensive documentation and analysis
that empowers Access users and developers to takeover existing Access
applications and enhance them," said Luke Chung, President and founder of FMS.
"Total Access Analyzer offers a cost-effective way to understand what's going on
in a database, detect errors, improve quality, and learn Best Practices. It
should be part of the quality assurance process during development and certainly
before shipping. If it doesn't pass Total Access Analyzer's review, it's not
ready for deployment. It's fundamental to our own Access development
Availability and Pricing
Total Access Analyzer 2010 is available immediately from FMS for $299.
Existing owners of Total Access Analyzer can upgrade for only $199. Total Access
Analyzer is available via ESD and also comes with a professionally printed user manual and CD.
Official Press Release