Hi Gadi.

>I had an index missing or corrupted error message on some of my tables.
>
>1. What can be the possible reaseon's for this error. (It acurred simultainsley on 5 tables)?

The most common reason is VFP not terminating properly (eg. user rebooting, server crash, etc.). However, there are a lot of other possible reasons, such as a flaky network interface card, a virus, etc.

>2. The help suggeested to delete or recreate the index file, but when I delete I loose the index data for good... what is the command/s I should use to solve this, i used VALIDATE DATABASE which didn't help.

You have to recreate the CDX from scratch. If you have a good copy of the table (even one with old data), copy its CDX over the damaged one, then REINDEX.

You might want to check out Stonefield Database Toolkit (SDT), which makes solving these types of problems painless. Because SDT maintains a set of meta data for your tables, it has all the information it needs to create corrupted or missing indexes by simply calling a method in one of our classes. For more information on SDT and the other features it has, check out www.stonefield.com.

Doug