See this Comm Center thread by Grady Owens (for Dennis Di Cicco). The compess/repair reduced the database by 20:1 so this needs to be an option in the scheduler. There is an API call in the Jet Database engine for this.

 

  
SVN Comment
 
 

  
Author
  
rbdenny
 
 

  
Repository
  
svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/scheduler
 
 

  
SVN Revision
  
825
 
 

  
Affected files
  
/trunk/Help/RelNotes.htm (Modified)

 
 

  
Check-in comment
  
Release notes have info for both of these changes. GEM:1745 
GEM:1650

 

 

  
SVN Comment
 
 

  
Author
  
rbdenny
 
 

  
Repository
  
svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/scheduler
 
 

  
SVN Revision
  
823
 
 

  
Affected files
  
/trunk/Help/ACP Scheduler Help.hhc (Modified)
/trunk/Help/Advanced.htm (Modified)
/trunk/MS Jet DB Compact Tool (Added)
/trunk/MS Jet DB Compact Tool/Jet compact utility is available in Download Center - Office - Microsoft Docs.url (Added)
/trunk/MS Jet DB Compact Tool/JetComp.doc (Added)
/trunk/SchedulerSetup/SchedulerSetup.vdproj (Modified)

 
 

  
Check-in comment
  
Include Jet Compact Utility to allow users to compact their DB without needing Access.
GEM:1745

 

Include the Jet Compact Utility and document it in Scheduler Help. Period.

Small problem... the JRO Jet Repair and Optimization is apparently no longer available. I looked all over. I did eventually find the Jet Compact Utility though. Still; looking for ways to do this programmatically, though it is required that all connections to the database be dropped. This means that ACP absolutely positively must not be running.