Is there a way you can be notified if there is an error when a query runs?

[Emma G]

Good afternoon,

I have designed a library database that uses queries to append a record from one table to another and then a delete query to remove it from the original table which seems to be working for me at the moment. When up and running my database will have many users and I am wondering if there is a way that I could be alerted if an error had occurred and either append or delete query had not run properly for some reason so that I could check for any errors in data. Could I program the database to send me an email containing details of an error? Or is there a log that a database keeps of this sort of thing? Are there any other notification options that I could use if an error happens when running a query? It would be helpful if I knew which record had failed to be appended or deleted during the process.

Many thanks.



Emma

[CJ_London]

you can - use the on error facility in code and put something there to send you an email.