VBA ignores an ADO error

[Ed]

I have an Acc2002 FE, Oracle BE. Trying to do an INSERT. The INSERT fails in
the the trigger. The connection.errors has an error but the ON ERROR
statement is not triggered. Anyone have any ideas?

 

[Douglas J. Steele]

Don't rely on On Error in this case then. After the query runs, check the
Errors collection yourself and base your next steps on that.

 

[Tony Toews [MVP]]

I have an Acc2002 FE, Oracle BE. Trying to do an INSERT. The INSERT fails in
the the trigger. The connection.errors has an error but the ON ERROR
statement is not triggered. Anyone have any ideas?

Please post the line of code that doesn't error out.

Tony

 

[Ed]

Gentlemen,
Sorry I haven't gotten back sooner. I had A MB die and take the C: drive
with it. That is another forum.

The command that is erroring out is an ado EXECUTE command that is doing an
INSERT. The DBA's & I have chased it back from the data from the error log
(I did insert code to check the ADO error class after the EXECUTE) to
determine what was going on.

It is a little dis concerning the the ON ERROR didn't pick up the ADO Error.
I was hoping that someone would say 'OH do this in . . . and th e problem
goes away." Doesn't sound like that will be the case here.

Thanks you for responding.