error 3705 (updating recordset)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • khelcross
    New Member
    • Jan 2012
    • 1

    #1

    error 3705 (updating recordset)

    Please help... error 3705 accur when i call GOupdate

    Private Sub GOupdaTe()

    Dim rsx1 As New ADODB.Recordset
    Dim cn As New ADODB.Connectio n

    If rsx1.State <> adStateClosed Then rsx1.Close
    If cn.State <> adStateClosed Then cn.Close

    Set rsx1 = New ADODB.Recordset
    cn.Open "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=C:\TPman agement_system\ DB\TP_mdb03.mdb ;Persist Security Info=False"
    cn.Mode = adModeReadWrite
    rsx1.ActiveConn ection = cn
    rsx1.Open "SELECT * FROM zusers"

    rsx1!timein = a.Text
    rsx1!SQL = b.Text
    rsx1!deduction = c.Text
    rsx1!payslip = d.Text
    rsx1!adrecords = e.Text
    rsx1!Edit = F.Text
    rsx1!report = g.Text
    rsx.Update
    rsx.Close
    End Sub

    -any suggestions is welcome.. thanks in advance
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    What is the error text?

    Comment

    • Killer42
      Recognized Expert Expert
      • Oct 2006
      • 8429

      #3
      Also, which line produces the error? And is this in Visual Basic 6, or MS Access, or what?

      Comment

      Working...