Using Recordset Locking

Recordset locking enables you to control how the Recordset object’s underlying tables are locked. You can specify read-only or write-only access, or both. Note that recordset locking applies only to table- and dynaset-type Recordset objects. Recordset locking doesn’t apply to snapshot-type or forward-only-type Recordset objects, because these are inherently read-only objects. However, shared table-read and shared table-write locks are placed by Microsoft Jet during recordset locking.