We deleted and rebuilt the indexes and still have the same problem. Any other ideas? The view is only on 1 table.

Thanks

>Hi Sally,
>
>>I'm not sure what you mean about re-generating the index from scratch.
>
>When you requery the view it accesses the index of the table. If that index is corrupt, it would explain your problem. I meant, you shoul delete the index of the table (or all tables) that the view bases on and try again to requery the view.
>
>Christof