Due to changes in the way the VBA Project and Access objects are stored in
Access 2000, a call to Jet's CompactDatabase method may not reclaim all the
space marked as deleted; whereas a Compact call issued via any one of the
following methods will handle all cases (as before).
- Access 2000 UI's "Compact and Repair Database" menu
- Either the /compact or /repair command line flags for msaccess.exe,
- The "Compact on Close" functionality added to Access
For more information, visit Trigeminal's website.