Lock Type property determines the lock type on record set while editing. It is derived from LockTypeEnum the default lock is adLockReadOnly. LockType property can be set before opening a Recordset to let the database know what type of locking the provider should use when opening the recordset..
Batch update locking in optimistic manner like record by record.
A record by record locking and provider will perform lock when update is called.
A record by record locking and provider will perform lock right after editing.
Set locking to read only mode where only SELECT statement can be performed to fetch the data from database.
Please leave your comments or queries under comment section also please do subscribe to out blogs to keep your self upto date.