Microsoft Remote Data ServiceMicrosoft Remote Data Service*
*Contents  *Index  *Topic Contents

Add Code to Submit Changes to the Database

Search for the words "Tutorial - Submit Changes to the Database." Copy the following script and paste it under the comment. 

SUB Submit_OnClick  ' Submit Changes button clicked.
  ADC.SubmitChanges ' Send changes to the DBMS.
  ADC.Refresh	     ' Refresh the recordset.
End Sub

When ADC.SubmitChanges executes, Remote Data Service packages all the update information and sends it to the server via HTTP. The update is all-or-nothing; if a part of the update isn't successful, none of the changes are made, and a status message is returned.

Up Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.