Total Visual Agent

With Windows NT Service!
Supports: All Access, Jet Engine and Visual Basic versions

All Access Products

Product Guide

Take a Tour

FAQs

Best
Middleware and Data Connectivity
Rave Reviews
 

Check for Updates

License Terms

Automate Repetitive Microsoft Access and Jet Engine Database Chores!

Microsoft Access Compact and Task Scheduler

• Are you tired of spending every Monday or the first of the month to manually run Microsoft Access reports or macros? Wouldn't it be nice if the reports were just waiting for you when you showed up at work?
• Do you forget to run end of day routines to send information or download data for the next day?
• Do you neglect maintenance tasks that are important for keeping your databases healthy?
• Would you like an easy to use system to run your tasks on a schedule?

If so, let Total Visual Agent be your professional Microsoft Access scheduler to manage tasks for an unlimited number of Access databases on your machine and across your network.

What Total Visual Agent Does for You

Total Visual Agent lets you define and schedule these tasks:

• Launch Microsoft Access and run your macro which can do things like print reports, download data, export information, and run your custom code
• Database compact and repair
• Database copy and zip backups
• Data extraction while users are in the database
• Collect database statistics like record counts to monitor usage
• Run any Windows command line

Define Your Own Schedules

Total Visual Agent lets you schedule and automatically perform these tasks multiple times per hour, once per hour, daily, weekly, monthly, or at a specific time in the future. Perform your daily chores in the middle of the night! You can even back up data while users are in the database (ideal for 24/7 environments) or execute your own custom code such as printing reports or data uploads and downloads.

Manage an Unlimited Number of Databases

Total Visual Agent manages an unlimited number of Microsoft Access/Jet Engine databases across your network. Install it on a PC that can see the databases you want to manage. It can even run as an NT Service to provide extra security and automatically restart if your PC goes down.

The administrative portion lets you specify what events you want to have:

• Create hourly, daily, weekly, monthly, or one time events

• Set the start time

• Specify an optional end time if you want to stop the tasks by a certain time. For instance, to make sure all the backups are done by 5 AM. If the deadline is hit, an email notifies you so you can adjust your tasks and events.

Define what you want to do:

• Select a database and the tasks to perform on it
• Specify a drive letter or directory and the tasks to perform on all the databases there (including sub-directories)
• Create a task group (a set of tasks you want to perform) and assign the databases or directories you want the tasks applied. This makes it easy to change the set of tasks you want to apply against multiple databases.

When the time arrives, it performs its tasks, then goes back to "sleep" to await the next event.

Total Visual Agent supports secured databases and lets you assign the security workgroups, user name, and passwords necessary to perform the tasks you need.

Audit Trail and Email Notification of Problems

Total Visual Agent offers a professional solution to ensure your Access/Jet databases perform optimally and are administered properly over time.

A complete audit trail is maintained in a table for every task performed. If an error occurs, an email is automatically sent to alert the system administrator. System administrators will also appreciate the ability to specify a cut-off time for tasks be completed. This ensures that as your databases grow and your tasks require more time to complete, Total Visual Agent never interferes with your business needs and alerts you if it runs out of time to finish.

Runs as a Windows NT Service

Total Visual Agent can run as a standard Windows program and has a "hidden" Windows NT Service. The service runs even without a user logged on to the computer, providing increased security and automated restart if the machine crashes. Schedule the tasks you want, and let Total Visual Agent take care of it.

Database Maintenance

So you've successfully deployed your Microsoft Access or  Visual Basic database application and people are happily using it. Don't rest yet! System administrative tasks are just beginning.

Whether your application is written in Microsoft Access, Visual Basic, C++, or Visual Studio .NET, if you rely on Microsoft Access/Jet Engine (*.MDB) databases, you need to periodically compact, repair, back up (copy or zip), and monitor them to achieve optimal performance, recover unused disk space, and prevent data corruption. 

Multiple Access Version Support

Total Visual Agent currently supports all Microsoft Access/Jet MDB database formats through Access 2007. It also supports Access Data Projects (ADP files).

A new version to support Access 2007 specifically and its new ACCDB format is under development. Contact us for more information if you're only using the Access 2007 ACCDB format.

Total Visual Agent Pricing for Access/Office/Visual Basic
Licenses                      Supports all Access, Visual Basic, and Jet
	Single	$299
	5 Seat	$899
	Upgrade Single	$199
	Upgrade 5 Seat	$599
Premium Support Subscription
	Single License	$299
	5 Seat License	$999
	More Information
Also Available as part of:
	Total Access Ultimate Suite
	Total VB Enterprise Suite
Runtime/Redistributable Version
A runtime version of Total Visual Agent is not available since it cannot be bundled within an Access or VB application (like a control). Total Visual Agent is a system administrative tool and usually runs on a machine separate from the deployed applications. Since it can manage databases across the entire network, its usefulness extends well beyond your application. Many developers and consultants, who need to bundle scheduled database maintenance with their applications, purchase multi-license copies of Total Visual Agent and resell it to their clients. Not only can you resell Total Visual Agent at full price, you can also charge consulting fees for installing and setting it up to manage your applications, all their other Access/Jet databases, and scheduling other tasks. For more information, please contact info@fmsinc.com.
Licensing Information
Total Visual Agent is licensed on a per installation basis. Each installation can manage multiple databases across the entire network (assuming the machine has rights to view the other network devices).