Code:
Stroldeml = Request.Form("sndoldml")
Strneweml = Request.Form("sndnewml")
Txtnwml = Request.Form("nwml")
pw = Request.Form("userpassword")
Set MyLogin = Server.CreateObject("ADODB.Connection")
ConnStr = "DRIVER={Microsoft Access Driver (*.mdb)};pwd=password;"
ConnStr = ConnStr & "DBQ=" & Server.MapPath("users.mdb")
MyLogin.Open(ConnStr)
SQLtemp1 = "SELECT * FROM CustRecords WHERE Cust_Username = '" & Request.Form("username") & "'"
Set rs = Server.CreateObject("ADODB.Recordset")
Set rs = MyLogin.Execute(SQLtemp1)
rs.Open SQLtemp1,MyLogin,adOpenDynamic,adLockOptimistic
If rs.recordcount > 0 Then
rs("Email2")=Txtnwml
rs.update
Error in rs.update.Kindly tell me where the error lies.I have tried using different lock types and different cursor types.I am using access database.
(0x800A0CB3)recordset doesnt support updating.limitation of provider or selected lock
