compacting BE database from front end

[wilkob]

I have a database that I have split into 2 parts: FE and BE database.
For the front end I have switched on that it is compacted on exit.
The backend however is not compacted this way. I did a manual compacting today and it went from 2MB to 200K !!!

Does anybody know some code to also company the BE on exit of the front end or on the click of a button??

Thanks

 

[fuzzygeek]

In a module, look up the (in the vba help) compactdatabase method and follow the examples.