Instead of reindexing,
Delete the TAGs (or index files) and index

use myfile excl
delete tag mytag
....
index on mykey tag mytag

Sorting on primary key before indexing speeds up process. You may also want to restart the server before you do anything. I have seen file locks on Novell (but not for VFP). Are your indexs local to your dbfs?


>Hi all,
>I've an accounting app running on a Novell network running on both TCP/IP and IPX/SPX protocol via Win 98 terminals.
>The problem is that index files get corrupted practically every day. Every time reindexing fixes the problem. How the index corruption manifest itself is that some records go missing when searched.
>I've tuned the Novell setting as suggested by other members on the forum (disabling write behind cache, enabling extended file locks etc) but the problem does not go away.
>Is there a methodology or software tools that I could use to narrow down and identify the cause of the problems?
>The tables involve have 4 tags one for the surrogate key, document number, date and deleted().
>What is funny is that every time when the index is corrupted, some records go missing. I've used browse to look at the table and found a strange behaviour for the missing records. With set deleted off, I could see those records and the delete mark is not there but with set deleted on, I could not see the records at all!
>Any help on this would be very much appreciated.
>Yau