Yes, packing with the keyword MEMO added, will help. I am not sure about what happens when copying, though.
Note that this bloat does not happen in a single user environment, as far as I know.
>Hmm
>
>That's news to this old VFP dog, Tore.
>The first time I've heard that one.
>Does packing help?
>If you copy to table to a new one, will the bloat follow to the new one?
>
>
>
>>>Just wondering if someone can point me in the right direction. I have a small file that have 3 memo fields, only 2 are used. Last month the ftp brok the 2Gb limit, I packed the file and it was reduced to 80Mb, i thought that perhaps it was a bit of a one off as the file has been used for 2-3 years recording lots of data. However this weekend I got the same error again, from 80mb to 2gb in about amonth. I had a backup and packed that, siz about 81 mb. I've checked and I can't see where I might be adding in lots of blanks etc. anyone any ideas where I might find the solution?
>>>~M
>>
>>Every time you change a memo field, a new record is created in the FTP. The old memo field is NOT reused. In other words, try to avoid using memo fields for continuously changing data.