We are creating a text file that is built by processing a number of VFP records. Each record holds the text that it generates in a memo field and then the entire thing is assembled at the end.

>Hi John,
>
>What you write data to MEMO field?
>
>MartinaJ
>
>>I have a new program where memo fields are over written many times during the day. I just realized that the memo files became huge and I assume that is because i am updating the memo field with new data every time the program runs it's process. I can pack the table and that fixes the problem but since it is a multiuser program I can't just do a pack every time someone runs the process.
>>
>>I am playing with the idea of using our old fake memo tables where we break apart the memo created in the cursor and save it as a series of text fields. Anyone got any other ideas? This problem is new to me.