MDE question

[Guest]

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

 

[Douglas J. Steele]

You can trap the error in Access, but you'll need to do this in the MDB and
recreate your MDE.