Hi All,

I just have a question about recordsets. I am using ADO control to connect to my Database.

adoConnF1.ConnectionString = "Driver={SQL Server}; " & _
"Server=FINANCIAL; " & _
"Database=finprod; " & _
"UID=sa; " & _
"PWD="

And I am using the following syntax to create a recordset..

Dim SalutationsRs as New ADODB.Recordset

strTitles = "SELECT * FROM SALUTATIONS"
SalutationsRs.Open strTitles, adoConnNAR, adOpenKeyset, adLockPessimistic, adCmdText


What I want to know is the settings for the lockedit and what each of the values do. I have here adLockPessimistic but I am not sure how that will affect others in a multi user environment.

And also what the other possible settings mean like dbLockOptimistic?

Could any provide myself with some insight or documentation on this?

Thanks
Anthony

Locks

http://msdn.microsoft.com/library/de...cursors_10.asp

Cursors

http://msdn.microsoft.com/library/de..._cursors_7.asp

P

adLockReadOnly Default. Read-only—you cannot alter the data.

adLockPessimistic Pessimistic locking, record by record—the provider does what is necessary to ensure successful editing of the records, usually by locking records at the data source immediately upon editing.

adLockOptimistic Optimistic locking, record by record—the provider uses optimistic locking, locking records only when you call the Update method.

adLockBatchOptimistic Optimistic batch updates—required for batch update mode as opposed to immediate update mode.