recordset.Open Source, ActiveConnection, CursorType, LockType, Options
Set the LockType argument to specify what type of locking the provider should use when opening the Recordset. The different types of locking are discussed in Chapter 8: Understanding Cursors and Locks.
The LockType argument can accept any of the LockTypeEnum values.