two tables hosted on a sqlserver database, with linked table. one table have a foreign key on the field "sendmode" if i try to update a record with a bad value on the field, access reports a runtime error. It's fine but i have only one message "odbc call failed". I would like to have the 2nd message (the why message) but access report only one message. do you have an idea to have the second message in ado another problem: if i forget to set a value in a field with null not allowed, access doesn't report the second message too... Thanks in advance, THE CODE Dim db As ADODB.Connection Dim rs As New ADODB.Recordset On Error GoTo erreur Set db = CurrentProject.Connection rs.Open "select sendmode from cmdclient", db, adOpenKeyset, adLockPessimistic rs!sendmode = "99" rs.Update rs.Close Exit Sub erreur: VBA.MsgBox db.Errors.Count ' only on message, i expect 2 End Sub With the same code in dao, this works fine! I have the 2 message!