Does a mde compact on close ?

  • Thread starter Thread starter Silvester
  • Start date Start date
S

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
 
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
 
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.
 
Back
Top