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
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"