Hi,
FWIW we don't use memo fields, the design of how they work leaves a lot to be desired, i.e. no backlink.

We use a dbf to store the info and present the data in memo format, if there is a problem a simple reindex is all that is needed.

The corruption is usually caused by a networking/hardware problem, and although some will say that utilities like Stonefield will fix the corruption, this is not always the case.

With blob type storage i.e. pictures, field that stores a link to the file location on the disk works well, and is stable.

>I have occasional problems where the user has erratic failures. Checking the tables shows no errors but when trying to pack a memo file it fails saying the file is invalid. I ran a program which read every memo to a local variable and then replaced it in the table with no effect. I resolved it in the end by copying out the whole memo information, removing the memo variable from the table, adding it back in and then copying back the information. Has anyone any similar experience, but with a better solution. I want to create an administration program for the user to resolve any corruption problems by reindexing etc. and would like a better solution for this problem.
>TIA
>Michael