>Well, the problem does reoccur. Once the view is create and saved I attempt to modify it and receive the error: Index does not match the table. Delete the index and re-create the index. I then have the exact same problems I had before. How should I delete the index and re-create it. Maybe that will fix my problem?
>
>Thanks.
Tom, make sure your database is open. USE the table exclusively, delete the index and close the table. Re-open the table exclusively and add the index back.
HTH