Refreshes the data in the current Recordset object from the underlying database.
Applies To
Required Files
msado15.dll
VC: adoint.h, adoid.h
Syntax
recordset.Resync AffectRecords
| AffectRecords | Optional. An AffectEnum value that determines how many records the Resync method will affect. Can be one of the following constants: |
|
Remarks
Use the Resync method to re-synchronize records in the current Recordset with the underlying database. This is useful if you are using either a static or forward-only cursor but you want to see any changes in the underlying database. Calling the Resync method cancels any pending batch updates.
Unlike the Refresh method, the Resync method does not re-execute the Recordset object's underlying command; new records in the underlying database will not be visible.
If the attempt to resynchronize fails because of a conflict with the underlying data (for example, a record has been deleted by another user), the provider returns warnings to the Errors collection but does not halt program execution. A run-time error occurs only if there are conflicts on all the requested records. Use the Filter property (adFilterAffectedRecords) and the Status property to locate records with conflicts.
Examples
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.