G
Guy RULKIN
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!
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!