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