Memo ARE susceptable to corruption, more so if running on Novell.
It is the way the data is appended to the end of the file if a block boundary is exceeded during an edit, a multiuser environment just complicates things more.
I have seen an edit on record 1 of a DBF in a Novell multiuser environment cause all memo references for the whole file appended to the end of the FPT and all block pointers set to record 1 in the DBF.
We did away with memos years ago. (For text entry only)
>I am considering to eliminate all memo fields and FPT files from
>my data. Instead, I will insert all lines of a FPT field to a record of a new table and then delete the FPT and its memo field.
>
>Do you guys think memo fields can increase the probability of corrupted tables as I think ? Or are memo fields irrelevant to data corruption ?
Regards N Mc Donald