Database update access
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!
|
