By damaged index, do you mean SQL Server index? The only index on it is the PK which is an integer and clustered. The only way I can drop it and recreate it is to drop the table (I believe) and recreate it. I might end up trying that. Other than that, no other views, etc. with that name.

Thanks for the reply.

John

>>I have a paramatized remote view (SQL Server). Sometimes - not always - when I add a record it disappears from the form. I do an insert into the view with the PK and then enter the rest of the data. The save does a tableupdate that returns .T. (buffering = 5). The textboxes bound to the fields go blank. When I try to browse the view in the datasession (private), I get an error message "Index does not match table. Delete the index file and recreate the index." When I exit the form and go back, the record is there.
>>
>>My views have no indexes. How can I get this error?
>
>Just guessing: could the message be coming from a damaged index in the underlying table? Or could you accidentally have a stray index with the same name as the view's name or alias somewhere along the VFP path.