>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 ?

As you said, memo file corruption can happen - ergo it cannot happen when you don't have FPT files.
But like Tore I almost never see corruption in practice, so probability is very low in a good network w/o FPT files - and ("very low" + X) when using them :-)
And IMO not using them when you want to store content Len()>254 is not an option anyway (although like you, I always "think twice" before introducing them).

So when you have the requirement to keep data files damage probability as low as possible, then I think you might want to use a Client/Server RDBMS,
because that way it can still happen but not be caused by crashing clients and network/hardware issues anymore.


-Stefan