>>When this append, some or all CDX (index) are corrupted. I try the VALIDATE DATABASE command, some times with the RECOVER option, I try to REINDEX, but I can’t recover all. I can't beleave I have to do a program to manage this. I realy need help on this, because I am losing a lot of time to recover the data.
>
>Stonefield Database Toolkit (SDT) provides this and many other capabilities. SDT will recreate corrupted indexes, repair corrupted table and memo headers, update the structures of tables at remote site without custom programming, and allows you to define new extended properties for database objects (such as field level security).
>
>For more information on SDT and other Stonefield products, check out our Web site at
www.stonefield.com.
>
>Doug
Once you get a corrupted index NEVER "just reindex". I always
DELETE TAG ALL
ERASE index.cdx
then rebuild the index from scratch. I always have a program call REINDX.PRG that has my index structures in it. So when there is corruption, I just call the REINDX program. The problem that you may be having is that the index's header information may be corrupted and a REINDEX does not correct or re-create an index's header.
Hope this helps //:^)
Larry