VBA ignores an ADO error

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?
--
Ed Perkins

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Ed" wrote in message
...
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?
--
Ed Perkins

Ed wrote:

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
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

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.
--
Ed Perkins


"Ed" wrote:

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?
--
Ed Perkins