New Features of Total Access Analyzer for Microsoft Access 2016, Version 16.0

Supports Microsoft Access 2016, 32-bit and 64-bit versions

Total Access Analyzer 2016 includes a 32 bit and a 64-bit version of its add-in to support both versions of Microsoft Access 2016. The setup program automatically detects the Access 2016 version you've installed and installs the appropriate one. It supports any operating system (32 and 64 bit) that Access 2016 supports.

Document All Database Types Supported by Microsoft Access 2016

Total Access Analyzer supports all the database types Microsoft Access 2016 uses including:

• ACCDB database format (from Access 2007 and 2016)
• Jet Engine/MDB formats (from Access 2000, 2002, 2003, 2007, 2010, 2013, 2016)

This means you can use Total Access Analyzer 2016 with Microsoft Access 2016 to document and analyze databases created by older versions of MS Access.

Note that Access 2016 no longer supports Access Data Projects (ADP) linked to SQL Server, so Total Access Analyzer 2016 cannot support them either.

Pass-through queries are processed by the back-end linked server that they are passed to and not Microsoft Access. Since Access and Total Access Analyzer cannot "see" the objects and functions there, table and field cross-reference errors were being identified.

To avoid such noise, Total Access Analyzer no longer cross-references pass-through queries. It can still document its SQL and other properties including columns if the connection string is provided. If the connection string is not provided, it flags the omission as an error.