>>>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
Index corruptions happen quite a bit with Fox 2.x. Since you had a power cut, this is probably what is wrong. You are going to have to close your tables, open them exclusively and run REINDEX on each of your tables. This should fix it. Good Luck.
-Ed
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only