Auto compact an Access database when a shrink percentage is reached

S

Stephane

Hi all,

I found this very interresting code which is not shown in many
manuals. If you want to auto compact when closing but only if a shrink
percentage can be reached. In the example below, we use 20. The database
will compact on closing if it can shrink by 20%.

You can enter this vba code on your Access database (like when the main form
is opened).

SetOption "Auto Compact Percentage", 20


I thought of sharing this info with you guys and gals.

Stephane
 
Top