Try to delete all indexes and rebuild them from scratch. The Reindex command sometimes cannot fix the problem if the header of the index file is corrupted.
>I have a table that has started to give bad results on a select query. If I run a query I get noo records or every record depending on my critiera. In reality I should get about 200 records out of 10000. There are no error messages or other indication of a problem. If I create a similar table and append the records form the corrupt table the second table gives the correct results.
>
>So it appears that I have a corrupt table. What is the best way to salvage this table? Built in tools or third party?
>
>Thanks
>
>Dennis
--sb--