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

When I run macro with Total Visual Agent, I get the error: "Microsoft Access location not specified or is invalid." 

Solution

This issue can occur in Total Visual Agent if you have two versions of Microsoft Access installed on your machine, but did not specify the path of the Microsoft Access .EXE. To resolve this, please do the following:

1. Open the Total Visual Agent Manager
2. Go to Tools, Options, and select the "Microsoft Access Locations" tab.
3. For each version of Access that you have installed, specify the correct path of the msaccess(version).exe.
4. Under "Access System Database" or "Access (version) INI File", specify the path to the *.MDW or *.INI.
5. Set the user ID and password, if necessary.

Additional Support Resources

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