[AccessD] Compact by code

Does anyone have code to compact an external database?  I am working on a
transformation / migration system.  Append operations go to an external
database using the IN 'SomeDatabase' clause in SQL.  The results are a huge
database bloat, not sure if it has anything to do with the IN clause or not,
but huge none the less.

So I need to do a compact on that backup database from code.

I see two methods in help - using DAO DBEngine, the other uses the JetEngine
object.  

I'm just looking for any pointers from anyone who does this already.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/