Compacting DB

[BobNTN]

I have a split DB and have it set to compact on exit.
However, I just noticed it does not compact the data file.
Is there a way to do both on close ?

 

[DJkarl]

Ideally you shouldn't need to compact the data portion too often. You can look at adding some code dbengine.CompactDatabase to your Front-End. If you are in a multi-user environment keep in mind that no one else can be using the database when you are compacting it.

 

[BobNTN]

Thanks
I'll just manually compact it when it appears to be growing.

It's a single user.