Does a mde compact on close ?

[Silvester]

Hi

I have set my mdb fe to compact on close. I then made an mde from that mdb.

Will the mde also compact itself on close ? How do I get the backend to
compact itself on close when the app ic closed ?

TIA

 

[Hugh N. Ross]

I am a little confussed. You mention a 'backend' as an mde. A backend mdb
ususlly contains data tables that can be read or written by various users
and compact on close is reasonable. An mde cannot be changed by users. A
frontend of forms, querys, reports etc. should bi compacted before making
the mde. No further changes are needed to the frontend during use.
Hugh

 

[Douglas J. Steele]

Compact On Close is actually of limited value, since the front-end doesn't
grow as much as the back-end.

There isn't a way to get the back-end to compact itself: you have to build
that functionality into your front-end. What I typically do is check whether
the locking file (.ldb) has been deleted for the back-end. If it has, I
rename the back-end to another file name (using the VBA Name function), then
use the DAO.CompactDatabase method to compact the renamed file to the
original file name.