>Hi All
>
>I find that I have to do constant maintenance of FPT files by PACKING. Is there a way to prevent zip file bloat by zipping and unzipping memo field contents on the fly?
>
>Your advice much appreciated. Thanks
>
>Best Regards
Zipping and unzipping would not completely solve the memo bloat problem - data will still have to be re-written to the memo file.
You might consider, as an alternative, having a bunch of files. Your main table would just have the filename.
Any of these options would be too complicated for my taste - I would just do the regular maintenance (pack the tables).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)