[AccessD] Compact BE on Close

If you have a FE/BE setup, and you've selected Compact on Close, then the
last user who exits will trigger a compact on the FE mdb.  But, the BE does
not compact.  This makes sense since the BE is not opened, and is simply
acting as a repository for data.

 

Has anyone set up a routine to compact the BE on close?

 

>From within the shutdown code in the FE, I can detect the last user, then
use the DBEngine.CompactDatabase function to compact the BE with a new name.
Then delete the original BE, then change the name of the compacted BE to the
original name, then finally close the FE.

 

Any words of wisdom?  If everyone's not too tired from pulverizing Naming
Conventions!  ;-)

 

 

Thanks!

Dan Waters

 

PS - I very consistently use the dfw naming conventions.