|
AUTOMATIC DATABASE MAINTENANCE WHILE
YOU SLEEP
Automatically Backup, Compact, Archive, Monitor and administrate
Access databases across your network from one convenient control
panel.
-
Manage an unlimited number of access database
backends with one single license.
-
Set unlimited number of maintenance jobs for each
database profile, your own centralized 'database of databases!'.
BACKUP YOUR ACCESS DATABASE WHILE IN
USE
Best Backup (R) technology determines if users are in your
database, then chooses the best method of backup including
extracting table data out to an external database. This creates a
reliable, date archived, corrupt free copy of your database tables
if you need them.
-
No need to have users exit the application before
backing up tables.
-
Flexible naming conventions for archived backups,
such as dates, incrementing numbers or backup sets. Never be
confused about backup
CONDITIONAL COMPACT IMPROVES DATABASE
PERFORMANCE
Compact all your access databases according to your own rules,
such as database size or percentage of bloat since last compact.
Regular compacting improves performance and reduces corruption.
ARCHIVE OLD BACKUPS AUTOMATICALLY FOR
VERSION CONTROL
Keep a certain number of days backups, or even a file size limit
such as 1GB of backups. Means you can genuinely 'set and forget' the
backup process while Access Autopilot purges old backup sets.
SCHEDULE MACROS FOR
ADVANCED MAINTENANCE TASKS
Access Autopilot will even run a custom macro in your database, to
perform more advanced tasks such as purging or archiving historic
records, or even executing another application.
- Setup a monthly or quarterly data purge that
cleans out old or superfluous records from tables, into another
external database, by executing your own custom macro scheduled
to run every month.
- Execute any command line using the scheduler,
e.g. run command.com to copy files or other advance tasks.
VIEW LIST OF USERS IN THE DATABASE
FROM THE SERVER
View all users in your access database, and even those who have
left the database in a suspect (potentially corrupted) state.
SEND POPUP ALERT ADMIN
MESSAGES TO USERS DESKTOPS
Send a popup admin alert to a group of users, such as those
currently logged into your database. Great for preventing new
connections, or asking users to log out for maintenance purposes.
CENTRALIZED
MANAGEMENT AND EXCEPTION REPORTING
View maintenance history in one quick glance, detailed activity logs
and exception reporting ensure you'll never accidentally forget to
backup or maintain databases.
MONITOR DATABASE STATISTICS TO
IDENTIFY BOTTLENECKS
Get quick statistics of the
database state including table list, file size, access version,
table and record counts, last compact and backup dates and last
compact size.
|
