Total Access Analyzer adds Access 2016 support

Total Access Analyzer understands how your database works and helps you find errors and performance bottlenecks. It includes the ability to detect over 100 types of errors and includes suggestions and performance tips. The comprehensive database analysis add-in finds problems before you ship and helps you understand what's really going on. Total Access Analyzer performs detailed analysis of your Access database objects individually and as a whole. By examining your entire database, it discovers complex relationships among objects, hidden problems and even unused objects.

Updates in 2016

• Supports Microsoft Access 2016, 32-bit and 64-bit - Total Access Analyzer 2016 supports all Microsoft Access 2016 database types including:
  • ACCDB database format (from Access 2007 and 2016).
  • Jet Engine/MDB formats (from Access 2000, 2002, 2003, 2007, 2010, 2013, 2016).
• Enhanced Cross-Reference of Aliased Tables - Total Access Analyzer 2016 performs more advanced SQL parsing to capture table names aliased in SQL Joins.
• New Suggestion: Incorrect Link to Subforms.
• New Suggestion: Relationship Field Cross-Reference and Field Type Comparison.
• Pass Through Queries - Pass-through queries are now processed by the back-end linked server and not Microsoft Access.
• Windows 10 Support.

About FMS

Founded in 1986, FMS is a privately held software company located in Tysons Corner, Virginia. FMS is a leading developer of products for Microsoft Access, SQL Server, Visual Studio .NET and Visual Basic communities. FMS customers comprise of small to large organizations including 90 of the Fortune 100 and every US federal government department.