Total Access Analyzer for
Microsoft Access 2010 Ships
Specific Ways to Create Better Microsoft Access Applications
VIENNA, VA – March 27, 2012 — 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. Microsoft Access is part of Microsoft Office and
is the world's most popular database product. 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 options.
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 containership.
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 saver."
New Features and Support for Access 2010
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 efforts."
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.
For more information on how to create better Access applications and learn Best
Practices, visit the Total Access
Founded in 1986,
FMS is a privately held software firm located in Tysons Corner,
Virginia. FMS is the world’s leading developer of products for
Microsoft Access developers, and a top vendor of products for the
SQL Server, Visual Studio .NET and Visual Basic communities.
Committed to innovation and quality, all FMS products are developed
by an in-house team of experts including several Microsoft MVPs,
published authors, and frequent conference speakers. FMS is a
Microsoft Gold Certified Partner, a Microsoft Independent Software
Vender, and member
of the Visual Studio .NET Integration Program (VSIP).