>We have one system that seems to be prone to the Database Container and tables getting corrupted whenever the user's PC locks up. Indexes get lost, and some fields have their data type and length changed.
>
>Is there a tool in Visual FoxPro to keep this from happening, or to help diagnose problems with the DBC. Or is there a recovery mechanism of some kind?

You can't prevent it from happening when something abrupt and abnormal happens. Look into Stonefield for a tool handle this.