Compact On Close

[rocco]

Hello,
newby here... so take it easy.
I want my database compact on close since it is an application which deals
with lot of insert/delete kind of things.
I checked the option compact on close.
Users can only exit the appliocation by clicking on a button.
The click event has just a line:
application.quit

Now, talking about 'compacting on close' I don't think that by quitting the
application is the same as closing the db. I means, it doesn't seem to
compact. I cannot be sure, I can just tell this because it seems the db
doesn't take any little 'extra' time to close. meaning he is doing
something...
I'm I right?
Nico

 

[Jonathan]

Hello,
newby here... so take it easy.
I want my database compact on close since it is an application which deals
with lot of insert/delete kind of things.
I checked the option compact on close.
Users can only exit the appliocation by clicking on a button.
The click event has just a line:
application.quit

Now, talking about 'compacting on close' I don't think that by quitting the
application is the same as closing the db. I means, it doesn't seem to
compact. I cannot be sure, I can just tell this because it seems the db
doesn't take any little 'extra' time to close. meaning he is doing
something...
I'm I right?
Nico

Nico,

This will not work if more than one person has this same user interface
open. That is, if more than one person can use the database concurrently,
Then each user should have their own copy of the user interface that is
linked to a common/shared data file.

Each copy can then compact on closing; no matter how the quit is initiated.

Luck
Jonathan