>Also, when I use COPY TO to copy the table to another table, I have noticed that the memo file of 300 MB turns into a file of about 30 MB in the new table. Why is that?
>I still have the large one, hoping that the deleted memos are somewhere in there. Although I've done a couple of searches on known phrases and haven't found any.Read
Re: Magic Increasing Memo fields Thread #
630993 Message #
631008 for an explanation of why the memo file bloats. Sorry, I don't know why your other memos are missing-in-action, but searching the memos won't find the deleted ones, since there is no longer a record that is pointing to the pre-revision memo data.
Randy Bosma
VFP - Because life is too short to code in something else...