>>>I have a table from a client that's giving error 41. When I scan through and try to read the memo fields, it throws some errors.
>>>
>>>I bought and downloaded CMRepair. When I run the memo test it offers on this table, it turns up a problem that I suspect is the main issue. But I don't see how I get the tool to fix the problem, and the Help isn't helping.
>>>
>>>Anybody been through this and can guide me.
>>>
>>>Tamar
>>>
>>>P.S. Yes, I've been very lucky over the years and never needed to fix memo corruption before.
>>
>>Do not know this tool, I would try it low level - the format is not that tricky. But guide you through might be a problem to me. If the data is not too private I offer to try it over here.
>
>Thanks for the suggestion. I had a months-old copy of the table and ended up writing code that scanned through, and tried to access the memo fields of each record inside TRY-CATCH. If it failed, I blanked the field and then pulled in the data from the old copy. That resolved the errors. I still need to see if I can grab the content for the memos of the newer records (from, say, a hex editor) and push it back in, but pleased that I was able to resolve the errors.
>
>Tamar
All things considered sounds like a big win. Congrats!