Update sql recordset

Add Comment. Post Comment. In this blog post we will be showing you how to update, add and delete records in a recordset. Previous Post Looping Through a Recordset. Next Post 05 — The Code Explained.

I am not sure I understand what you want to do. Search icon. Boris Boris 1. This does not answer the question. Did you want to ask a question? Then please do that and ask a new question. But read How to Ask first.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked Related Hot Network Questions.

Question feed. Stack Overflow works best with JavaScript enabled. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Please rate your experience Yes No. Any additional feedback? Important Changes to the current record are lost if: You use the Edit or AddNew method, and then move to another record without first using Update.

You set the Bookmark property to another record. You close the Recordset without first using Update. You cancel the Edit operation by using CancelUpdate. Note To add, edit, or delete a record, there must be a unique index on the record in the underlying data source.

In this article.