>Hi all,
>
>What is the possibilities for missing index? I have 20 users using a system
>with the database resides in a server in dbf format.
What do you mean with "missing index"? If you use compound indices, all indices are in the same file (CDX extension). It is very unlikely for individual index to be erased accidentally.
A user might accidentally erase all indices (that is, the CDX file), through the Windows Explorer.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)