>Thanks for all the replies
>What I didn't understand is where the bloat is coming from and the entries in the table, including the memo fields, are not editable by users. Also out of 900,000 records the number of deleted records are 8-10 so the bloat is not coming from there.
>I have set blocksize to 0 in the calling prg, however the table was most likely not created with the blcoksize parameter set to 0, so your program above should sort that out. I think that this situation best explains the bloat that I am seeing
>Thanks for the reading material Tore, it explains the bloat, expecially with the blocksize parameter.
>The file is that bit too big and used too often and in too many places to have a running pack command at each use, I was thinking about running a nightly run that tries to pack.
>~M

Since we can not look into your app, we do not see how you fill the memos :)
-> Solution one; Code References for your field and see how it's filled / changed. See the article mentioned above too
-> Solution two: Hack the fpt with an HEX editor and see whats in the unused blocks. The file structure of fpt is declared in vfp's help.
You might write a little prg that exposes the single blocks as well, it's not to tricky.

Lutz