How to create an Updateable recordset in ODBC workspace.

[jagilman]

I need to open a recordset of selected records in an ODBC workspace, loop thru the records one at a time, and set one of the field values to a new value before going on to the next record. The problem I am having is an error message stating "the recordset is not updateable." Any ideas regarding what I might be doing wrong??

Here is the statement that opens the recordset.

Set AllItemsRS = con1SW.OpenRecordset("sp_SWOrderItems", dbOpenForwardOnly)

AllItemsRS is the DAO.Recordset object
con1SW is the connection object
sp_SWOrderItems is a stored procedure Select statement that creates my group of records

Any ideas would be appreciated!
[sig]<p>John A. Gilman<br><a href=mailto:gms@uslink.net>gms@uslink.net</a><br>[/sig]

 

[THoey]

I don't see much listed on the topic, but does dbOpenForwardOnly make it read only? Did you try a different &quot;type&quot; and see if that works?

Hope that helps...
[sig]<p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?[/sig]

 

[jagilman]

Thanks Terry, I have tried all the different types that refer to being updateable. No luck yet. [sig]<p>John A. Gilman<br><a href=mailto:gms@uslink.net>gms@uslink.net</a><br>[/sig]