<div>
You might try<br />
<br />
Application.Lock<br />
<br />
and <br />
<br />
Application.Unlock<br />
&nbsp;before and after SQL Calls
</div>


You might try

Application.Lock

and

Application.Unlock
 before and after SQL Calls

<div>
Recordset Cursor Operation Conflict errors could be due to pessmistic locking?<br />
<br />
What does the application lock actually do? &nbsp;What happens if two processes try to lock a table at the same time - wouldn't i get the same problem?<br />
<br />
Bendecko
</div>


Recordset Cursor Operation Conflict errors could be due to pessmistic locking?

What does the application lock actually do?  What happens if two processes try to lock a table at the same time - wouldn't i get the same problem?

Bendecko

<div>
Having a bit of a clean up of &lt;unlocked questions&gt;<br />
<br />
This would almost certainly work I now know to use the connection object for INSERTS and UPDATES and leave the recordset for SELECTS<br />
<br />
thanks<br />
<br />

</div>


Having a bit of a clean up of <unlocked questions>

This would almost certainly work I now know to use the connection object for INSERTS and UPDATES and leave the recordset for SELECTS

thanks



<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I've got a site where I have quite a few DB access commands. &nbsp;Most commonly they are in the form:<br />
<br />
objRecordset.Open strSQL, DB_CONNECTIONSTRING, adOpenKeyset, adLockPessimistic, adCmdText<br />
<br />
I've been occasionally getting 'Recordset Cursor Operation Conflict asp errors' &nbsp; Is this due to the adLockPessimistic parameter and the number of users in the system increasing?<br />
<br />
Any suggustions?
</div>
</div>


Hi

I've got a site where I have quite a few DB access commands.  Most commonly they are in the form:

objRecordset.Open strSQL, DB_CONNECTIONSTRING, adOpenKeyset, adLockPessimistic, adCmdText

I've been occasionally getting 'Recordset Cursor Operation Conflict asp errors'   Is this due to the adLockPessimistic parameter and the number of users in the system increasing?

Any suggustions?

Recordset Cursor Operation Conflict

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.