SubmitChanges Method (RDS)

Submits pending changes of the locally cached and updatable Recordset to the data source specified in the Connect property or the URL property.


Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and Windows Server 2012 Compatibility Cookbook for more detail). RDS client components will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to WCF Data Service.


DataControl.SubmitChanges DataFactory.SubmitChanges Connection, Recordset  


An object variable that represents an RDS.DataControl object.

An object variable that represents an RDSServer.DataFactory object.

A String value that represents the connection created with the RDS.DataControl object's Connect property.

An object variable that represents a Recordset object.


The Connect, Server, and SQL properties must be set before you can use the SubmitChanges method with the RDS.DataControl object.

If you call the CancelUpdate method after you have called SubmitChanges for the same Recordset object, the CancelUpdate call fails because the changes have already been committed.

Only the changed records are sent for modification, and either all of the changes succeed or all the changes fail together.

You can use SubmitChanges only with the default RDSServer.DataFactory object. Custom business objects cannot use this method.

If the URL property has been set, SubmitChanges will submit changes to the location specified by the URL.

Applies To

DataControl Object (RDS) DataFactory Object (RDSServer)

See Also

SubmitChanges Method Example (VBScript)
Address Book Command Buttons
CancelUpdate Method (RDS)
Refresh Method (RDS)