Database - automatically compact and repair

[humph]

Can anyone give me guidance or code on how to automatically compact and repair.

There is something going on in my database when I open and it goes from 3.7kb to 26 kb each time it is opened - I cant find out why - ope to the why suggestion but another option is to automatically compact and repair

Thanks in anticipation.

Humph

 

[pbaldy]

There's an option in Tools/Options to compact on close.

 

[humph]

Many thanks for this

Humph