• I found the right SQL Statement.

    sql = "Update web Set answer1='" & answer1 & "'" & " where identity=" & identity

    Thanks a lot for your replies.

    SQL seems to be very delicate.