[Originally posted by Avi]

How do I trap and change the description of errors if they happen like these:

Run-time error '-2147217900 (80040e14)':
[MICROSOFT] [ODBC MICROSOFT ACCESS DRIVER]
The changes you requested to the table were not successful because they would duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

Run-time error '-2147217900 (80040e14)':
[MICROSOFT] [ODBC MICROSOFT ACCESS DRIVER]
You cannot add or change a record because a related record is required in table
'Tbl_ServiceDetails'