>I'm not even sure how to phrase this question. When I am in a Project I can make a connection to a SQL database. I can then use that connection when creating a Remote View. In the process of creating that Remote View I can select the unique field of the table and those fields that I want to have as updatable. This is all visual and it works. Now I would like to be able to do the same thing programmatically and I have no idea how to do it. I can make the connection, no problem. I use the SQLExec() to select the data to a cursor, but it is not updatabe.
>
>Basically I want to change a field in the Remote View and have that change updated automatically in the SQL Table. Can anyone point me in the correct direction?
>
>TIA
>DJ :o)

See MSKB#Q138094 How to Create Updatable Views by Using SQL Passthrough
at http://support.microsoft.com/support/kb/articles/Q138/0/94.asp