Resync

Syntax

recordsetobject.Resync [AffectRecords][, ResyncValues]

Description

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.

Parameter	Description
AffectRecords	The optional AffectRecords parameter is one of the AffectEnum constants that specifies which records are to be affected. The default is adAffectAll.
ResyncValues	The optional ResyncValues parameter is one of the ResyncEnum constants that determines which values can be overwritten. The default is adResyncAllValues.

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

See Also

Requery, Errors.

Example

objRecordset.Resync adAffectAll