>I have a user with tables that don't match the information in the database. I would like send him a small app that would run the VALIDATE DATABASE command with RECOVER. But when RECOVER is used in runtime, the error message "Command Only Available In Interactive Mode" is returned. Is there a another way to clean up a corrupted database in runtime, or will I have to get a copy of his data and VALIDATE it in my developer version of VFP5.
>
>Thanks
VALIDATE DATABASE is really only needed after making structure changes to the database and its tables- something not normally done from an end-user app. So normally, VALIDATE DATABASE is not needed except for by the developer.
You could, if you so desired, write your own version of VALIDATE DATABASE that scanned through the dbc records and checked for the existence, location and strucutural integrity of every database object, and give the user the option to correct any problems.
Erik Moore
Clientelligence