Updatable Property
Returns a value that indicates whether you can change a DAO object.
Return Values
The return value is a Boolean data type that is True if the object can be changed or updated. (Snapshot- and forward-only–type Recordset objects always return False.)
Remarks
Depending on the object, if the Updatable property setting is True, the associated statement in the following table is true.
| Object | Type indicates |
|---|---|
| Connection | Data in the connected database can be changed. |
| Database | The object can be changed |
| QueryDef | The query definition can be changed |
| Recordset | The records can be updated |
| TableDef | The table definition can be changed |
The Updatable property setting is always True for a newly created TableDef object and False for a linked TableDef object. A new TableDef object can be appended only to a database for which the current user has write permission.
Many types of objects can contain fields that can't be updated. For example, you can create a dynaset-type Recordset object in which only some fields can be changed. These fields can be fixed or contain data that increments automatically, or the dynaset can result from a query that combines updatable and nonupdatable tables.
If the object contains only read-only fields, the value of the Updatable property is False. When one or more fields are updatable, the property's value is True. You can edit only the updatable fields. A trappable error occurs if you try to assign a new value to a read-only field.
The Updatable property of a QueryDef object is set to True if the query definition can be updated, even if the resulting Recordset object isn't updatable.
Because an updatable object can contain read-only fields, check the DataUpdatable property of each field in the Fields collection of a Recordset object before you edit a record.