Index problem

[Richard Kreiss]

Last night noted a change in the index behavior of one file at a client's
site.  When enter is pressed, nothing happens it requires a value to be
entered.  As I mentioned this is only happening in one file all of the
automatic indexes. These indexes are rebuilt each night after everyone is
off the system.  All of the indexes no matter what the primary key is has
been affected.

My thoughts are, a bad record has been added or a record has become corrupt.
Or, I need to  rebuild the free chain.

Can  the free chain be rebuilt while the file is being accessed?


Locating a bad record is going be time consuming if this is the problem.  I
might be able to limit the records needing to be checked by using the
modified date and/or the creation date.

Anyone have any additional suggestions?


Richard Kreiss
GCC Consulting
rkreiss at gccconsulting.net