Memo Size - Corruption

[DaBuzz]

I have a Foxpro 2.x application that has many fields utilizing the memo field. Occasionally we get corruption where data from many memos are pulled into one. I am in the process of fixing one of these occasions and my final step prior to putting back into production is to take the fixed database and append into a clean database.

However this time my .FPT file grew almost 10x in size on the append.
After fixing the corruption my size were
.dbf 20,209,260
.cdx 4,782,080
.fpt 13,243,968
After appending into a clean database
.dbf 20,209,260
.cfx 7,493,632
.fpt 121,917,056
My concern is the .fpt file. I have run fptfix on it with no change. I have also done Pack Memo

Any suggestions or was this that messed up and 121mb is the correct size??

 

[rgbean]

Have you tried just a "straight" PACK? I believe you can shrink the index file by recreating it (or maybe just a REINDEX will do).

Rick

 

[rob444]

Use this utility to repair:

http://www.rbftp.com/transfer/foxpro/cmrepair26.zip

Rob.