Supports Newer ACE and ACCDB Database Formats

Microsoft Access 365 introduced new ACCDB database formats to support BigInt and Extended Date field formats on linked SQL Server tables.

If the Access 365 version (32 or 64-bit) installed on your machine supports the new format, Total Visual Agent does too using the Access Database Engine (ACE) that it exposes.

Improved Service Configuration with Automatic (Delayed Start)

The default settings for configuring the Total Visual Agent Service is recommended to be Automatic (Delayed Start) rather than Automatic. The manual, help file and web page are updated with this information.

Setup Checks for Installed Version of ACE

Total Visual Agent's setup program checks for the currently installed versions of the Access Database Engine (ACE) before installing ACE 2010, 32-bit, if none is found.

In earlier version of Access, ACE was sandboxed inside Office and not available to external programs like ours, or even Microsoft programs such as PowerBI and SQL Server Migration Assistant (SSMA). So, we were always required to install ACE. This wasn't a problem, but due to issues caused by some Microsoft Windows Updates, we now only installs ACE when necessary.

Setup Program Supports Upgrades and Uninstall Better

Some registry issues were resolved.

• The original release was Version 17.00.0056 on January 26, 2022.
• An update of the documentation on the Service configuration was released in March 2022 without any changes to the program.