Access Error Trapping OnError macro and send email notification without manual intervention using Sharepoint

Access 2007 has OnError macro.
On error we just add the record to SharePoint linked list in Access.
Alerts are setup on this SharePoint list which generate automatic email.