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