>>>>>We experience a hard crash on the server where my VFP 3.0
>>>>>application resides. After the crash, I repacked and
>>>>>reindexed the tables. We had some small errors show up
>>>>>within the tables - trash written to the tables. I took the
>>>>>trash out and once again repacked and reindexed the tables.
>>>>>One of the indexes was really bad so I deleted it and
>>>>>reindexed again. We started having some of the memo fields
>>>>>show up with the wrong records. After a couple of days of
>>>>>this, I copied the tables, deleted the old copy and renamed
>>>>>the tables back to the original ones. Everything went fine
>>>>>for a couple of days. Now, once a week or so, we have a user
>>>>>find a memo field with the wrong record. It is usually the
>>>>>same user. One other thing, these are records that have
>>>>>been entered since we have made the changes.
>>>>>Any suggestions? I'm about to pull my hair out!!!
>>>>
>>>>try foxfix or norton's file fix (if it works for 3.0).
>>>
>>>Where do I get Foxfix? What am I looking to fix? I'm new with
>>>working with network problems and have fixed other database
>>>problems with no trouble. Please excuse my ignorance.
>>>
>>>Susan
>>
>>someone here should know where to find foxfix. if no results, try
www.hallogram.com. it sounds like the table records aren't pointing to the right spot in the .fpt. foxfix is supposed to be able to read dbf and fpt files and fix problems like these.
>
>Click on the Xitech advert at the top of the screen - they wrote it so should know where to get it from!
>
>Ian
FoxFix is Ok for that work. Try the FIXALL.PRG utility and then MEMOSCAN tool (both came with FoxFix).