Updatable Property

See Also    Example    Applies To

Returns a value that indicates whether you can change a DAO object.

Syntax

BOOLGetUpdatable(VOID);

Remarks

Depending on the object, if the Updatable property setting is True, the associated statement in the following table is true.

The Updatable property setting is always True for a newly created CdbTableDef object and False for a linked CdbTableDef object. A new CdbTableDef 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 CdbRecordset 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 CdbQueryDef object is set to True if the query definition can be updated, even if the resulting CdbRecordset 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 CdbRecordset object before you edit a record.

Snapshot- and forward-only–type CdbRecordset objects always return False.