Error Handling on Record Insert in Access:

 This script counts the number of errors that occur during a database insert. If the insert statement conflicts with a unique table index, then the error count will be equal to 1 or greater. Server-side scripting can then permit error handling.

Code:

Highlight