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