I have noticed that after deleting records by Jackcess the file size is not reduced. Could you add some "compact" method to utilize space used by deleted records?
it's definitely a tricky problem. you will basically see the same behavior in ms access, which is why they have the "compact and repair" option (which basically just copies everything to a new database file). i've contemplated trying to add a "compact and repair" option to jackcess, but i'm not sure if jackcess currently understands enough of the access format to safely run such an operation.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
it's definitely a tricky problem. you will basically see the same behavior in ms access, which is why they have the "compact and repair" option (which basically just copies everything to a new database file). i've contemplated trying to add a "compact and repair" option to jackcess, but i'm not sure if jackcess currently understands enough of the access format to safely run such an operation.