You can't 100% prevent it. In fact, data files from every program can be corrupted. Application design plays a big part in prevention. Never edit the data directly. Either use buffering or views. BROWSE is especially bad. There are other ideas at
http://www.craigberntson.com/Articles/kb005.htm>Is there a way to prevent tables to become corrupted ?
>It is happening too often. Anybody knows why ?
>Thanks
>Alessio
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer