>>>>>Is there a way to index a view so I can do a seek?
>>>>
>>>>Trish, just SELECT you view and index it as if it is a table.
>>>
>>>But I have to write to to it and want to use the buffering. Plus, if we upgrade to SQL server we have been trying to just use views.
>>
>>You stil wil be able to update the indexed view, and you are just limited to use only row buffering for your view. For indexing purpose it doesn't matter which view you are using -local or remote.
>
>I can't use table buffering?

No, if you try - you will get the message "Command cannot be issued on a table with cursors in a table buffering mode".
But you are able to switch to row buffering, index, seek and then return to table buffering mode, of course if it is not interfering with other conditions and requerements which you have in your form.