>>>What are the factors that can make an index fall out of step with its table, Can network etc cause this ?
>>
>>Mark,
>>What do you mean "fall out of step"? What type of symptoms are you having?
>>
>>-Ed
>>
>> Its Foxprox 2.6 , We had a power cut last monday, since then all Fox Dos processes have been running slow (very) some files are not reading at all & it seems the master table's index is not updating with the table
I have had a similar problem and the only thing I found that fixed the problem was to remove the index's and then rebuild them.
Just reindexing did not fix the problem.
Maybe I'm wrong and someone else has an easier fix.
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com