You received some good tips. I would recommend SDT...

>My application (.exe) is soon to find a new home a long way from its creator. Eventually, its .dbc, .dbf, dcx, dbc or cdx will corrupt. Every VFP .exe ever created comes with along without warning.
>
>Restoring with a backup is always the last solution. In the short term I want to have a menu option called "Reorganize". What I would like to do is to release the index files and rebuild them programmatically, using Alter table for the pk and fk's and the index command for the other indexes. I have no idea what to do with the validate database command.
>
>Any suggestions?
>
>Thanks
>
>Dallas