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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement