https://www.webmaster-forums.net/crss/node/1014385 en https://www.webmaster-forums.net/web-database-development/updating-multiple-listings-one-form#comment-1082986 <p>My first recommendation would be to move this to a stored procedure (if possible). If that isn't possible then consider using the UpdateBatch method. You'll have to add a LockType of adLockBatchOptimistic, and a CursorType of adOpenKeyset. </p> <p>Example:</p> <p>On Error Resume Next<br /> case Request.Form("sub_update_institutions")&lt;&gt;""<br /> sqlstr="SELECT * FROM institutions;"<br /> rs1.Open sqlstr,con,3,3<br /> do until item_index &gt;request.Form.Count-2<br /> for i=1 to 7 step 1<br /> rs1.fields(i)=request.form(item_index)<br /> item_index=cint(item_index)+1<br /> next<br /> rs1.MoveNext()<br /> loop </p> <p>If Err.number = 0 Then<br /> rs1.UpdateBatch<br /> Else<br /> rs1.CancelBatch<br /> End If</p> <p>rs1.MoveFirst<br /> rs1.close<br /> call show_updated()</p> Mon, 28 May 2001 14:34:49 +0000 Peter J. Boettcher comment 1082986 at https://www.webmaster-forums.net