No trigger exception message

  • Thread starter Hansjörg Zimmermann
  • 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
 
H

Hansjörg Zimmermann

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 ?
 
S

Sylvain Lafontaine

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.
 
G

giorgio rancati

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
 
H

Hansjörg Zimmermann

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
 
H

Hansjörg Zimmermann

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trigger error does not surface 1
Update trigger works in SQL Server but NOT in Access adp datasheet 5
Acces Project- insert trigger problem 13
Updates to table through enterprise manager roll back without warning 3
CLR Trigger Rollback 6
Rollback transaction doesnt work when DataAdapter.Update() throws exception caused by RAISEERROR in 5
Can't trigger error message with docmd.gotorecord 1
Complicated (?) error handling 6

Top