Overtyping Data

Edit online

If the entire column is displayed and the data is not defined as read-only, you can type over it.

Read-Only Data

Data in a column is read-only, and cannot be overtyped if:

  • The DB2® specification defines the column as read-only. For example, if the column is displayed as part of a joined view, consists of an expression, or is a DB2 Catalog column.
  • The column is defined as read-only on the Describe Columns panel (displayed by using the COLUMNS command).

If one or both conditions are true, Access protects the data and you cannot edit it. However, the data is not protected for any condition that Access cannot detect. For example, Access may allow a user to edit a column that the user does not have explicit authority to edit. If an attempt is made to modify such data, a DB2 error message is displayed.