>>>>I am making a database and table maintenance class that has buttons for PACK, RECALL ALL, and REINDEX, and whatever else I might need. I thought I would add a button that does "Clean Up Database" and VALIDATE DATABASE. As I recall, the "Clean Up Database" pad from the Database menu does the same as:
>>>>
>>>>USE mydatabase.dbc EXCLUSIVE
>>>>SELECT mydatabase
>>>>PACK
>>>>
>>>>Is that the right code?
>>>>
>>>>So what else do I need to put in this thing?
>>>
>>>Be aware that VALIDATE DATABASE is not available outside the VFP environment...
>>
>>...and the RECOVER option is not available in code, only from the Command Window.
>The vfp6 help confirms what you say about the RECOVER clause. It doesn't confirm what Eric said about the command itself, but I can believe that he's right.
>
>I don't know if VALIDATE DATABASE would even be a good command to make available to users, if Eric were wrong. I'm open to suggestions about what are good maintenance options to provide users in a very light-duty environment.


Have you looked into the Stonefield Database Toolkit? It probably has the functionality you're looking for and then some.