J
jaylou
I am not sure if this is the correct group or not, but here is my question.
I have an Access front-end Program that uses an MDE so I can't modify
anything in it. The program links to a SQL server 2000 DB. I created
trigger on a table to prevent insertions of certain setup options. When you
try to insert the options you get a huge error message and my "raise error
MSG" gets lost in all the words. (Too much for the users to read)
Is there a way to suppress the Access error MSG and have it display only
what I want it to say? In SQL I am using Raise error ("error MSG", 16, 1)
TIA,
Joe
I have an Access front-end Program that uses an MDE so I can't modify
anything in it. The program links to a SQL server 2000 DB. I created
trigger on a table to prevent insertions of certain setup options. When you
try to insert the options you get a huge error message and my "raise error
MSG" gets lost in all the words. (Too much for the users to read)
Is there a way to suppress the Access error MSG and have it display only
what I want it to say? In SQL I am using Raise error ("error MSG", 16, 1)
TIA,
Joe