Error Handling

[KabirPatel]

I have recently upsized an Access database to SQL Server. The .adp is for the most part working fine.

However, when an end user tries to create a duplicate record in one of the Primary key columns of a Form he gets a SQL Server error message as follows:

"Violation of Primary Key constraint. Cannot insert duplicate key in object myTable".

This is obviously not a very useful error message. What would be the best way to ensure that a more useful error message is returned?

I have considered adding code to the "After_Update" event of the cell in question. This however seems long winded. Is there an easier option?

Thanks
Kabir

 

[Adeptus]

Not really...
I'd suggest Before_Update, not sure if it makes much difference though