|
| |
Product Overview
Perform backup, and repair/compact
operations on Microsoft Access MDB files for Microsoft Access
version 2000 and 2002(XP) or newer. The repair and compact process creates a backup copy and compacts the
database file back to itself. Can be scheduled and runs unattended. Works
on databases that are password protected or secured with a workgroup file
using Access security. Display any connected users computer and login
names that have databases open. Maintains an “event viewer” style log
of all activity and can generate a report.
Installs on Windows 98, NT, 2000, XP workstation or
server versions. MDBCompact can be installed on a PC without
Microsoft Access already installed. Manage your databases from any PC that
you can specify a valid network path or drive letter path to those
databases.
|
About Compacting Databases
As you change data in a database, the database file
can become fragmented and use more disk space than is necessary.
Periodically, you need to compact your database to defragment the database
file. The compacted database is usually smaller and often runs faster.
Also, the compact process will repair any inconsistencies and help fix or
prevent corruption of the database file.
You must close the database file before you compact it. In a
multi-user environment, other users can’t have the database file open while you’re compacting it. If the
database file isn’t closed or isn’t available for exclusive
use, the process will not complete.
Because MDBCompact
creates a copy of the database, you must have enough disk space for both
the original and the duplicate databases. The compact operation fails if
there isn’t enough disk space available.
The
compact
process maintains all the data, security permission
settings, and version from the original database. MDBCompact only works on
Access 2000 and 2002(XP) version or newer databases.
|
Features
|
Feature
|
Description
|
| Manage
Applications
|
Stores
an unlimited number of database applications to run the repair and
compact on. Saves a name you provide, the path and file locations,
database password or login credentials.
|
| Backup
|
Perform
a backup on one or all applications entered. A copy of the original
database MDB file is made as a BAK file in the same folder.
|
| Compact
|
Perform
a repair and compact on one or all applications entered. A backup is
created first, then the database is compacted back to the original
file name. If an error occurs at anytime, the original is always
restored.
|
| Current
Users
|
View a list of users currently using any of the database
files anytime. See the computer name and login that is active. This
is helpful since backup and compact operations cannot complete if
there are current users.
|
| Activity
Log
|
Displays
an “event viewer” style list with details form. Log entries are
made for the backup and compact completion or failure, errors and
possible causes, and current users causing failures. You can delete
log entries or clear the entire log at once.
|
| Log
report
|
Generate
a report preview from the activity log. The report can be printed or
exported to HTML or text formats and saved.
|
| Unattended
scheduling
|
Perform
the backup and compact operations at a scheduled time. Use the
Windows Task Scheduler to run MDBCompact with the “/a” switch in
the command line. This gives total scheduling flexibility and the
log captures all activity while it runs.
|
|
|
