I'm trying to pass an error code from a MSSQL 6.5 database trigger to ms access 97, but can't get it work.
The code part that raises the error is:
I also tried RAISERROR ("someerrordescriptionhere",16,-1).
When inserting a new recordset into the table, the trigger checks the biz rules. if the recordset infringes the biz rules, an error should be passed to access. However, access doesn't even recognize the error, although - when inserting with the sql query tool from sql 6.5, the error msg is being raised properly.