Take a look at "How to Create Updatable Views by Using SQL Passthrough"
http://support.microsoft.com/support/kb/articles/Q138/0/94.asp

>I'm creating an SQL view, you know...
>
>CREATE SQL VIEW viewname AS SELECT .... FROM ... etc.
>
>How do you make the view updateable, as you can in the view designer?