The following code worked fine (I think) yesterday.

<%
sql = "select as_scoping,a_scoping,as_planfile,a_planfile,as_envclr,a_envclr,"
sql = sql + "as_rwclr,a_rwclr,as_const,a_const "
sql = sql + " from TIP where tip_id=" & lnTIP_ID	
oPage.open sql, oConnection, adOpenKeyset, adLockBatchOptimistic, adCmdText
with oPage
.fields("as_Scoping").value = formatdate2(request.form("as_Scoping"))
.updatebatch
end with
%>

Today it fails on the update, BUT the new date value IS stored in the table. Not only that but the new date is stored to most but not all of the records in the table even though there is only 1 record that fits the criteria. Running a record count loop confirms that only 1 record was selected. The formatdate2 function is simply to deal with a blank date coming from the form.

The error message is
Error Type:
Microsoft Cursor Engine (0x80040E21)
Multiple-step operation generated errors. Check each status value.
/tip/save_tippage1_edits.asp, line 395


Any ideas on what's causing this? Other functions that write to this table seems to work OK so I don't think its a permissions issue.
Thanks for any insights.