I am developing an Access front-end linked to SQL Server back-end. In
the triggers I raise an error as in:
RAISERROR 44447 'The record cannot be changed. RI rules require a
related record in table "Locations"'
However all I get in Access when this trigger raises its error is:
"ODBC --insert on a linked table 'Tasks' failed.
Is it possible to trap the error and create my own more meaningful one?
I have tried to trap errors in the BeforeUpdate and FormError etc
events but am unable to trap it.