>We have a large table that we cannot pack the memo file.
>If I type 'pack memo' it will get as far as analizing the file but before it actually does the pack the error 'Bad or missing memo file' is generated. The file does exists but how do I fix the problem. I tried using the utility 'Foxfix' but that was unsuccessful.
The problem is likely some duplicate or illegal memo pointers. Fox cannot pack that. There is a cheap solution:
use the COPY TO AnotherTable command. Then AnotherTable will have your data and you should be able to pack
it. However the cheap solution does not tell you which record memo pointers had the problem.
You could try our 'Recover' uility at
http://www.abri.com/It should remove the problem pointers and make a list of the offending records/memos so you can take corrective
steps. Simply removing the symptoms will give you a false sense of solving the problem.
-----------------------------------------------------------------
Paul Lee ........... Abri Technologies .........
http://abri.com/ 'Recover' - top rated FoxPro/dBase file repair utility.