>Did you tried "PACK" command over your table? This command not only remove records marked for deletion, but also allows to pach the FPT file content by removing gaps (unused space) in it. There is and option "MEMO" that allows you to run PACK without touching of records marked for deletion )if you use them in production).
Hi Vlad,
This error occured as I was appending records from an FP2.5 table to a VFP7 table during a conversion/upgrade. The error occured around record 2600 of over 50,000 so even if I pack the memo file I dont think I can stay within the 2MB limit. I was hoping there was a 'set' command or something to get around this limitation.
Instead I am going to try to store the data as character records in a table, copy them into an edit box for editing, then strip out carriage returns etc. and save each line as a record back to the table.
I tried to find something that does this in the 'download' section of the UT but was unable.
Thanks for you help.
The day you take complete responsibly for yourself, the day you stop making any excuses, thats the day you start to the top. - O.J. Simpson
Great advice from a questionable source...