|
Subject:
|
Database update access
|
|
Posted By:
|
inershado
|
Post Date:
|
9/16/2003 9:41:27 PM
|
Hi there...i am haveing a problem with my Web page....i use this code to update my database records.....
<%Sub doit()
conn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("../database/users.mdb") & ";"
Set rs = Server.CreateObject("ADODB.Recordset")
SQLStmt = "update tbl_authors set score='" & Server.HTMLEncode(teliko) & "' where ID=" & str_authors_ID
SQLStmt = SQLStmt & request.form("ID")
rs.Open SQLStmt, conn, 2, 1
response.redirect("alldone.asp")
%>
<%End Sub%>
....but i am getting this message :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query
It worked ok befor some days but when i reinstall my windows i am trying to use my web page and it doesnt work!
I am useing Windows Xp profession with IIS 5.1!
...i wonder if anyone could help me! Thanks!
|
|
Reply By:
|
DaveGerard
|
Reply Date:
|
9/23/2003 11:26:18 PM
|
Try this and see what happens.
rs.Open SQLStmt, conn, 3, 3
|
|
