See Also
Applies To
Table object, Dynaset object
Description
Indicates whether records can be updated. Not available at design time; read-only at run time.
Syntax
recordset.Updatable
Setting
The Updatable property settings are:
Setting Description
True The records can be changed.
False The records cannot be changed.
Remarks
The recordset is the Recordset property of a data control. In the Professional Edition, it can also be an object variable identifying an open Table or Dynaset.
A Dynaset may contain fields that can't be updated. These fields might be fixed or contain auto-incrementing data, or the Dynaset might be the result of a query combining updatable and non-updatable Tables.
If a Dynaset contains any non-updatable fields, the value of the Updatable property on the Dynaset is False. You can, however, edit the individual updatable fields. You can use the Fields collection of a recordset to inspect the Attributes property of each Field and identify updatable fields before you edit a record. As long as you edit only updatable fields, no error occurs when you use the Update method, even if the Updatable property of the recordset is False.
If you change the value of a non-updatable field and then use the Update method, an error occurs.