UPDATE information in access problem

[KingIsulgard]

Code: Select all

'Check if current password is correct
 If currentpassword = password Then
  set passconn = server.CreateObject ("ADODB.Connection")  
  passconn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("accounts.mdb")
  passSQL = "UPDATE userlist SET password = '" & newcodedpassword & "' where checkname='"& checkname &"'"
    passconn.Execute(passSQL)
    set passSQL=nothing
   'Delete the cookies and sessions
    Response.Cookies("rememberbusiness").Expires = date() -1
  Session("username") = ""
  Session("loggedin") = false

When I run this, I get an error that this line is incorrect
passconn.Execute(passSQL)
can someone help me please?

[jakyra]

What's the error? Likely it's a problem with your SQL statement although I don't see anything obvious.