Excellent question.Quote:>I'm confused between the locking mechanisms of an ADO recordset that is
>using a SQL statement. Take the following code:
> rsCustomer.LockType = adLockPessimistic
> rsCustomer.Open "SELECT * FROM Customers WITH (NOLOCK)"
>What takes precedence, the recordset or the SQL statement?
If only there were *any* documentation on the subject!
In my experience, the SQL text seems to take precedence -- and
sometimes the adLockPessimistic fails all by itself.