No trigger exception message

  • Thread starter Thread starter Hansjörg Zimmermann
  • Start date Start date
H

Hansjörg Zimmermann

Hi, i have a problem with the handling of error messages produced by a
trigger. I have defined a trigger which contains business logic and checks
some rules before storing the data. In case of a error i use the RAISERROR()
command.

When i use MS-Access on one PC to inserted records in the table the error
message issued by the trigger appears, which is the expected result.

On a other installation MS-Access does not show the message, it just says
nothing and does not allow me to store the record. Because it does not show
the error message of the trigger, the user has no idea what the reason is.

Does anyone know, which setting allows to specify how trigger messages are
handled ?

Thanks for your reply
 
Thanks for your hint. Since this is a known bug since january 2005 i am
supprised that there is still no patch from microsoft. Even no workaround
is mentioned.
Did you have the same problem and found a workaround ?
 
No surprise for me and and there is no workaround that I know of - excerpt
for the obvious choice of upgrading to A2003 - and don't expect a patch from
MS as it seems that ADP2002 is no longer supported by them.
 
Hi Hansjörg,

I do so
----
....
....
RAISERROR ('Your Error Message ', 16, 1)
ROLLBACK TRANSACTION
....
----
the trigger messages are handled.
(Access2002 sp2, Msde2000 sp4)

Bye
Giorgio
 
I'm working with A2003, and the bug is still there.

The only workaround is to recode the validation which is stored in triggers
again on the GUI-side. Very ugly.

Tanks for your help
 
Hi Giorgio

I now, that this works in general. I develop my software on two machines
(Desktop and Notebook).
On one machine i get the message, on the other not. Both have Windows XP
SP2, and A2003 SP1.
 
Back
Top