I am trying to do a batch update with the following statements:





objRS.Open txtCommand, strConnect, adOpenStatic, adLockBatchOptimistic, 

adCmdText



while Not objRS.EOF

  objRS("Status") = Request.Form("newStatus")

Wend





objRS.UpdateBatch





and I get the following message:



Provider (0x80040E54)

Number of rows with pending changes exceeded the limit.





The retrieval works if I print the record rather than change the Status.



Thanks for any help.

Phil

Go here:

http://search.support.microsoft.com/kb/c.asp



Select "All Products", Type in "Error 0x80040E54" as your search criteria

(without the quotes). Click Go



Try the third link returned



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "Phil Kimble" <phillip.a.kimble@g...>

To: "ASP Databases" <asp_databases@p...>

Sent: Wednesday, June 27, 2001 10:56 PM

Subject: [asp_databases] Batch Update Problem





: I am trying to do a batch update with the following statements:

:

:

: objRS.Open txtCommand, strConnect, adOpenStatic, adLockBatchOptimistic,

: adCmdText

:

: while Not objRS.EOF

:   objRS("Status") = Request.Form("newStatus")

: Wend

:

:

: objRS.UpdateBatch

:

:

: and I get the following message:

:

: Provider (0x80040E54)

: Number of rows with pending changes exceeded the limit.

:

:

: The retrieval works if I print the record rather than change the Status.

:

: Thanks for any help.

: Phil