Example of my code:
With rs
For x= 0 to nn
..addnew
.fields("a").value='gg'
.fields("b).value='ff'
.update
Eccc..
Next
End with

I nedd to insert abegin and commit tra s to speed up the write of data.


Question:

-Where a insert begin a d commit trans?
- how to open the table for that?
- in order of speeding and writing data (googoling..) a user suggest to use:
!namers='ff'
Instead
.rs(....e cc
Is correct?
Note,
I use adojet connetion and access and vb6 classic

Tks