Surfacing SQL Server errors

[J. M. De Moor]

SQL Server 2000
Access 2000 ADP

Is there a way to surface the actual SQL errors that fail CHECK CONSTRAINT
clauses? The form's ON ERROR event is triggered but the DataErr property
always returns 2757, which is not helpful. I would especially like to know
which CHECK CONSTRAINT fired the error, but would settle for the correct
Error column from the SysMessages table. Is this too much to ask in Access?
(It is a breeze in other languages using ADO.)

Thanks for any help.

Joe