ADO data control data can be either read-only or modifiable.

To create an application that modifies data using ADO data control

Set ADO data control CursorLocation property. Options are:
- Server Side
- Client Side
Set ADO data control LockType property. The optimistic concurrency is recommended.
Set ADO data control CursorType property. Options are:
- Keyset Cursor
- Dynamic Cursor
- Static Cursor
Make sure the OLE DB provider supports the chosen option.
Set the data-bound control's properties, as needed, to allow updateability. Note that some controls do not allow updating.

For more information about these properties, see the ADO documentation.

See Also