[AccessD] Compact by code

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BackUpManager.mdb'

William

----- Original Message ----- 
From: "John Colby" <jwcolby at ColbyConsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Monday, November 21, 2005 3:02 PM
Subject: [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/
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>