Background

Total Visual Agent lets you easily schedule and execute the repetitive tasks your databases need. Schedule a wide range of tasks and run them in a fully automated and audited manner. Set start times and end times, and receive emails if anything goes wrong.

Problem

The Total Visual Agent manager fails to run with this error: “Could not open system workgroup C:\ProgramData\FMS\Total Visual Agent\15.0\TVAGSYS.MDW” 

Solution

Total Visual Agent 2013 requires a copy of Microsoft Access 2007, 2010 or 2013 (32-bit version) to be installed on the machine to run. This can be the standard or free runtime version of MS Access.

With Access installed, this error should not occur. However, we have seen this error when Microsoft Access 2013 is installed from the download from Office 365. You can check to see which version of Access 2013 you have under the Microsoft Access, About Details (under File, Help). If it states "Microsoft Office 365", then it means Microsoft Access was downloaded from an Office 365 subscription. That version of Microsoft Access 2013 is slightly different from the standard installation of Access 2013.

Fortunately, there’s a simple solution, install the Microsoft Access Database Engine 2010 Redistributable. Once installed, Total Visual Agent 2013 will successfully load and run.

Note, this issue does not occur in Total Visual Agent 2016, because ACE is installed as part of the setup program.  

Additional Support Resources

• Support Options
• Product Information
• FAQs
• Updates
• User Manual
• PDF Fact Sheet