Search code examples
databasems-accesstriggerssql-updatems-access-2016

MS Access "After Update" events: raise error


Raising error using After Update is not possible, while using Before Update is possible. 'After Update' is not fired at all, while 'Before Update' is fired

To test it, I create a RaiseError event on Before Change:

before change event definition

Whenever I change a record, an error box is shown:

enter image description here

But when we set RaiseError on After Update nothing is shown after record changes.

after update definition

I use Microsoft® Access® 2016.


Solution

  • Finally after two days exploration, I find the problem. The errors defined on After Change is not shown as an error message box. They are logged on Application Log.

    enter image description here