I have an MDB with SQL Server 2000 linked tables. I need to trap errors that are caused by a rule on the SQL server table. For example, we have a foreign key relationship between a couple of the SQL server tables. When I try to delete a record in one table and there are related records in the other table, the error is displayed as shown in the attachment.
How can I trap that error and display a more user-friendly message?