[AccessD] BE Compact, Backup, and Server Restart

Gregg greggs at msn.com
Fri Oct 1 18:38:17 CDT 2004


We have developed a VB program that will (1) compact an Access Database
using Jet Comp, (2) optionally saves a copy, and (3) optionally restart the
system.  We put it in our customer's server task scheduler to restart the
server, compact the BE, and save a copy.  Anyone interested in using it...
enjoy.  We would love to have some feedback.

http://highimpactsolutions.com/shareware/Default.htm

Below are the technical details.

This program is designed to run from a command line.
The purpose is to compact an Access database using the
JETCOMP.EXE command line arguments with the addition of
-b:{fullpath to backup location} and -r for rebooting the PC.

If the -dest: argument is not found the database will be
compacted to the -src: location.

C:\PROGRA~1\HISCOMP\HISCOMP.EXE -src:"c:\mydb.mdb" -v4 -r
would compact a database to its original location and
reboot the machine.

For a list of command line arguments run
C:\PROGRA~1\HISCOMP\JETCOMP.exe /?



        Gregg Steinbrenner
High Impact Solutions
<http://www.highimpactsolutions.com>
           972-223-4559





More information about the AccessD mailing list