Just to test I did rebuild the keys on that file, it still only left me with a few of the keys in the index. The rest where still missing.


>>It sounds like index corruption to me. The only way to verify that is to re-index the table.
>
>I guess it's possible that reindex may not rebuild them, if they're so mangled that VFP doesn't see them. If it would see them and report an error, then yes, I'd expect the reindex to do it, but with this sort of symptom... I guess odds are 50:50.
>
>>>I just had a problem where most of the keys in the index disappeared.
>>>
>>> The index didn't appear corrupted and the file could still be accessed.
>>>
>>>Anyone seen anything like that before or suggest a cause?
>>>
>>>The table is accessed via forms in the application and also by some scheduled programs.
>>>
>>>Thanks
>>>
>>>Nick