Updatable Property

See AlsoproUpdatableSee

Applies To

Table object5RHH0MW, Dynaset object25TLT8.

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 variableZ3R9Q5 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 query3MZK9H9 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.