If he use VFP 8.0 I would go for TRY/CATCH instead of ON ERROR, but that may not be enough because the corrupted database may not cause an error. Worse than not crashing, it may give wrong results.

A tool like SDT would be best. Otherwise, a scheduled maintenance routine could do a VALIDATE DATABASE RECOVER on the database wich could correct some problems.

>Why not create your own error routine?
>
>IE On error do myerrorroutine with error(),program(),lineno()
>
>from within there you could then detect what lines running that caused the error etc. with program(), lineno()