sql server - How can I manage error code SQL in MS access form database?

Question

I want manage SQL server error code in access form sample duplicate error from SQL server

Answer 1

In Access VBA, you need to use:

On Error GoTo Error_Handler
' YOUR CODE HERE
.
.
.
Return_Label:
Exit Function

Error_Handler:
'What goes here depends on the data access model
Resume Return_Label