Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

adodc.recordset.addnew problem

Whenever I run my program and reaches this part:

With Adodc1.Recordset
.AddNew
a = Text3.Text
b = Text4.Text
c = Text5.Text
.update
End With

This error appears:
Run-time error '-2147217842 (80040e4e)':
Operation was cancelled.

(The .addnew is highlighted)

Help?! :'(

Comments

  • zaib_awanzaib_awan Member Posts: 9
    : Whenever I run my program and reaches this part:
    :
    : With Adodc1.Recordset
    : .AddNew
    : a = Text3.Text
    : b = Text4.Text
    : c = Text5.Text
    : .update
    : End With
    :
    : This error appears:
    : Run-time error '-2147217842 (80040e4e)':
    : Operation was cancelled.
    :
    : (The .addnew is highlighted)
    :
    : Help?! :'(
    :

    Use This
    rs.open " Select * from Table",connection String,adOpenKeyset,adLockOptimistic

Sign In or Register to comment.