How does it grows?
You can "Save copy as" for compacting the file, but without it the empty space will be used after some while.
I'm already doing following:
1) "save copy as (compacted)"
2) open the copy and delete all the records from the main input table
3) close the file and insert it into the container field
What I might try is to save a new copy after record deletion, then insert the new copy.
I don't know if it brings something and anyway I can't understand why the copy stored in the "updater" database doesn't make it grow as the copy stored in the "master" database does.
I can't save the new copy after deletion, apparently.
In my procedure I open the saved, compacted file with Open URL. The opened file has a trigger "OnFirstWindowOpen", which deletes the records and then closes the file. I tried to put a "Save copy as" in this script trigger, before the "Close file", but it doesn't do nothing, so I guess that "Save copy" step doesn't work on files called by Open URL ?
Anyway I'm stuck...
If you have any ideas...