>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
Try a simple REINDEX on the table...
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca