AddNew - UpdateBatch Problem +++++++++++++++++++++ 
Author Message
 AddNew - UpdateBatch Problem +++++++++++++++++++++

I have the following code:

.......
Dim titlelist2() As Variant, titlelist2() As Variant
...............
Rs02.Properties("Batch Size") = .......
.................
 For x = 1 To ....
        .................................................
        .................................................
        .................................................

        Rs02.AddNew titlelist2, titlelist2
 Next

    Rs02.UpdateBatch
...................................
.....................

what I get (in the row with the addnew ...)
is error 3265 (ado) : Item cannot be found in the collection corresponding
to the requested name or ordinal. WHY? WHAT?
titlelist2 and titlelist2 are both onedimensional arrays with same nr of
elements.
can someone pleeeeeaase help me?

question 2:
has somebody out there a routine for resetting the autonumber column of an
access db back to zero. I mean with ADO.

thank you,
Rickx



Sun, 30 Nov 2003 22:00:18 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. More problems with AddNew and UpdateBatch

2. UpdateBatch/CommitTrans work for AddNew?

3. No data in database after .AddNew and .UpdateBatch

4. How to use mutiple .AddNew's and .UpdateBatch

5. AddNew and Updatebatch

6. UpdateBatch/CommitTrans work for AddNew?

7. ADO UpdateBatch problem

8. Updatebatch on a Disconnected ADO Recordset Problem

9. UpdateBatch problems with disconnected recordset

10. UpdateBatch problems with disconnected recordset

11. UpdateBatch problem

12. Problems with UpdateBatch

 

 
Powered by phpBB® Forum Software