I am getting the following problem .
Maximum locks exceeded per file.Increase the Locks per file.
I am trying with the following code.
Set rstemp = New ADODB.Recordset
rstemp.Open sCond, adoConAccess, adOpenStatic, adLockPessimistic
is there any effect of using adlockpessimistic ?
Any disadvantages of using adlockpessimistic instead of adlockoptimistic
Pls let me know ..