ADO » Recordset » Resync

recordsetobject.Resync  AffectRecords, ResyncValues
The optional ResyncValues parameter is one of the ResyncEnum constants that determines which values can be overwritten. The default is adResyncAllValues.

Refreshes the data in the current Recordset object by re-synchronizing records with the underlying (original) database.

The Resync method is used to re-fetch the data from the underlying data source and to update (resynchronize) the values in the current Recordset. Since this is not a re-query, new records in the database will not be added to the Recordset.

If you call this method on a server-side Recordset, you will get an error. Likewise, you cannot use this method on client-side, read-only Recordset objects.

If the call to this method fails because of conflicts with the underlying date (such as a record having been deleted), warnings will be returned to the Errors Collection and a run-time error will be generated.

This method has two optional parameters.

The optional AffectRecords parameter is one of the AffectEnum constants that specifies which records are to be affected. The default is adAffectAll.

AffectEnum Constants

Constant Value Description
adAffectAll 3 Cancels all pending updates including those hidden by a filter
adAffectAllChapters 4 Cancels all pending updates in all child (chapter) recordsets
adAffectCurrent 1 Cancels only the current record
adAffectGroup 2 Cancels updates only on records that passed through the filter in effect

ResyncEnum Constants

Constant Value Description
adResyncAllValues 2 Default, can overwrite all values, and pending updates are cancelled
adResyncUnderlyingValues 1 Can only overwrite underlying values, and pending updates are not cancelled


objRecordset.Resync adAffectAll

See Also: