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 is made, and a status message is returned.

Next