Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Ado, Sqlserver, Errors

Discussion in 'Information Technology' started by Guy RULKIN, Jul 28, 2006.

  1. Guy RULKIN

    Guy RULKIN
    Expand Collapse

    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,


    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,
    rs!sendmode = "99"
    Exit Sub

    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!
  2. Loading...

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page