Indicates whether an application can insert, edit, and delete data in a table.
Syntax:
property CanModify: Boolean;
Description:
Check the status of CanModify to determine if an application can modify a dataset in any way. If CanModify is True, the dataset can be modified. If CanModify is False, the table is read-only.
CanModify is set automatically when an application opens a table. If the ReadOnly property of a table component is True, then CanModify is set to False.
CanModify can also be False because:
- Another application currently has exclusive write access to the table.
- The table is read-only by database design.
Even if CanModify is True, it is not a guarantee that a user will be able to insert or update records in a table. Other factors may come in to play, for example, SQL access privileges.