|
|
|
Total Visual Agent, by FMS
Inc., lets you easily specify the tasks, files, and when events
should execute. The hierarchical display makes it easy to
see your scheduled events, and what's assigned to them. |
 |
Individual databases can be assigned with specific tasks to be
performed on the database. The new Task Group to an event,
and then assign a common set of tasks to be performed on
multiple databases. (click on image to enlarge) |
New Features for Total Visual Agent 2003!
Total Visual Agent Service:
Total Visual Agent 2003 includes the option to run the program as a
Windows NT Service. This service runs even without a user logged on
to the computer, providing increased security and automated restart
if the machine crashes. This feature has been requested over the
years, but it required the latest Microsoft technology to enable the
management of multiple Access security workgroups.
Support for Access 2003: Total
Visual Agent 2003 includes support for Microsoft Access 2003, plus
continued support for all previous versions of Access, Visual Basic,
and the Microsoft Jet Database Engine.
Once configured, Total
Visual Agent runs in the background using a minimal amount of system
resources while waiting for the next event. When the scheduled time
arrives, Total Visual Agent wakes up, performs the task, then goes
back to sleep to wait for the next scheduled time. If you do not
have tasks scheduled during the day, you don't even need a dedicated
machine. Just let Total Visual Agent run in the background and leave
your machine on when you go home!
Total Visual Agent lets you define and schedule
these tasks:
-
Database repair and compact
-
Database copy and zip backups
-
Data
extraction while users are in the database
-
Launch
Access and run a macro which can run your code
-
Collect database statistics like record counts to monitor usage
-
Run
any 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 tasks 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 can manage an unlimited number of
Microsoft Access/Jet Engine databases across your network. Simply
launch it from any PC that can see the 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.
Manage individual databases or specify a directory
and manage all the databases within it and its subdirectories
automatically. You can also define a list of tasks in a Task Group
and assign databases or directories to it.
A Professional Solution
Total Visual Agent offers a professional solution to
ensure your Access/Jet databases perform optimally and are
administered properly.
A complete audit trail is maintained for every task
performed, and 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.
New Features for Total Visual Agent for Access 2003!
- Total Visual Agent Service: Total Visual Agent 2003
includes the option to run the program as a Windows NT Service.
This service runs even without a user logged on to the computer,
providing increased security and automated restart if the
machine crashes. This feature has been requested over the years,
but it required the latest Microsoft technology to enable the
management of multiple Access security workgroups.
- Support for Access 2003: Total Visual Agent 2003
includes support for Microsoft Access 2003. In addition, it
continues to support Access 1.0, 1.1, 2.0, 95, 97, 2000, and
2002, and Visual Basic 3.0, 4.0, 5.0, and 6.0.
- New User Manual and Help File: Total Visual Agent
2003 includes a new user manual and online help file to support
the new features.
|
Feature |
Benefit |
|
Manage multiple
databases (including secured and password protected databases) |
An unlimited
number of databases can be managed by one installation of Total
Visual Agent (provided the machine can see across the network
and has sufficient rights). |
|
Perform multiple
tasks on each database |
Several tasks
can be performed on each database in the order you specify. |
|
Automated,
"hands-off" execution |
Once setup, the
tasks are executed on schedule without the need for user
intervention. |
|
Complete audit
trail |
Every task on
every database is documented with start and end times. |
|
Email
notification of problems |
An email is
automatically sent to the system administrator if a problem is
encountered. |
|
Create named
Task Groups to contain a list of actions to perform against a
group of databases |
An advanced
enterprise feature to simplify the execution of the same tasks
on multiple databases. |
|
Automatically
perform actions on all the databases or files located in a
specified directory |
An advanced
enterprise feature to simplify the management of all databases
or files in a directory (no need to know names in advance). |
Available
Actions (Tasks)
|
Action |
Benefit |
|
Compact/Repair
the database |
Recover unused
disk space, optimize the database, and update query statistics,
which can improve query performance. The database is repaired if
Jet determines it is necessary. |
|
Copy and zip
databases or create rolling "archive" versions |
Multiple backups
ensure you can easily fall back to a previously saved copy of
your database. |
|
Perform "live"
data extracts |
Databases cannot
be copied while users are in it. Data extracts backs up data
when you would otherwise not be able to make a copy. Ideal for
24 hour a day operations. |
|
Run macros and
other command line actions on a database |
Provides the
flexibility to schedule any action you can launch from an Access
macro such as downloading or uploading data, printing nightly
reports, running reconciliation analysis, etc. |
|
Track statistics
on the number of objects in your database |
Keep tabs on the
growth of your important databases. |
|
Track statistics
on the number of records in your tables |
Track trends in
data acquisition. Can be used to monitor usage by hour of day. |
The Trial version of Total Visual Agent is designed to provide
you with the opportunity to evaluate the power of Total Visual
Agent. It is identical to the retail version, except for the
following limitations:
- The trial version will only operate for 30 days. After that
time, the program will expire; however, your settings are saved
and can be used by the full version.
- The trial version does not allow you to import settings
files from other installations or versions of the product. The
full version allows you to import settings that you created in
other versions.
- The trial version does not include a printed user's guide,
but it includes an online help file. The full version ships with
a complete user manual.
Installing the Demo
Download the setup file, and run it from your local computer. The
setup may require you to reboot your computer, so be sure to save
your work before running the setup.
If you will have an active connection to the Internet while running
the setup, download the small setup:
Total Visual Agent 2003 Trial - Small Setup
If you will not have an active connection to the Internet while
running the setup, download the full setup:
Total Visual Agent 2003 Trial - Full Setup
Differences between Small Setup and Full Setup
The small setup does not include the Microsoft .NET Framework 1.1,
Service Pack 1. When you run the setup, it is downloaded from the
Internet if it is not already installed on your computer.
The full setup includes the Microsoft .NET Framework 1.1, Service
Pack 1. It does not require an active Internet connection during
installation.
|
Pricing |
 |
 |
|
Total Visual Agent for Access/Office/VB - Single
|
|
$295
|
|
Total Visual Agent for Access/Office/VB - 5
Users |
|
$895 |
Above products support all versions of Access, JET and Visual
Basic
Total Visual Agent is licensed on a per installation basis. Each
installation can manage multiple databases across the entire network
(assuming the machine has sufficient rights).
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 goes 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. |
|
Total Visual Agent:
-
Works with Access and Visual Basic
-
Manage all databases with one install
-
Scheduled events run
automatically
|
|
|
System Requirements:
-
Pentium processor or better
-
Windows 98, 2000, ME, NT 4.0 or 2003
-
16 MB RAM (32 recommended)
-
10 MB available hard disk space
-
Access 2003,
-
2002, 2000, or 97
|
|
|
