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.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.