Dan Waters
dwaters at usinternet.com
Mon Nov 21 17:30:52 CST 2005
John, The following two procedures are kept in a standard module. The CompactBE procedure is called from the Main screen Exit button click event (the only allowed way to close normally). If you are the 'last man standing', the BE (or external mdb) will open and close. That file is set to 'Compact on Close' (A2K and up?). This has worked well for a few years. HTH, Dan Waters -----Original Message----- 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