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

  • : 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.

Howdy, Stranger!

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

Categories

In this Discussion