Updatability Property
The Updatability property specifies the supported methods on the Recordset object.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Updatability") [= value]
Parts
object
Expression that evaluates to an object in the Applies To list.
value
Integer that specifies supported methods, as specified in Settings.
Settings
| Constant | Description |
|---|---|
| DBPROPVAL_UP_CHANGE | The Update method is supported. |
| DBPROPVAL_UP_DELETE | The Delete method is supported. |
| DBPROPVAL_UP_INSERT | The AddNew method is supported. |
Data Type
adInteger
Modifiable
Read/write
OLE DB Property
DBPROP_UPDATABILITY
Remarks
The Updatability property should be used in conjunction with the IRowsetChange property. If the IRowsetChange property is set to True and Updatability is not set, the provider determines which methods are supported by the IRowsetChange property.
The Updatability property is considered successfully set if all of the bits specified are supported. It is not necessary for the provider to disable support for the bits that are not set, although providers may do so to optimize performance.