I have an application that has linked tables to an Oracle database. If the user enters values into the MS Access form and commits by moving to the next record, Oracle may send back an error. It could be one of the following:

Foreign key violation
Primary key violation
Not null constraint
Index violation

Instead of having Access display the actual Oracle error message, like it is currently doing by default. I want to display a more user-friendly description of the error.

For example, if the user leaves a required column blank, I want to return a message saying "Ensure you have entered all required fields", rather than the Oracle error "ORA-0XXXX Foreign key constraint violated".