Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Output by changing conn.Execute to Response.Write:
What does this error mean, and how do I overcome it??? Pls help!
[Thanks in advance|Hope I helped you]
Exodus300
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Code:
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("database/forums.mdb")
If Request.Form("replyto") = "" Then
r = 0
Else
r = Request.Form("replyto")
End If
conn.Execute "INSERT INTO Forum (ReplyTo, DatePosted, TimePosted, PostedBy, Title, Message) VALUES (" & _
r & ", '" & Date & "', '" & Time & "', '" & Session("UserName") & "', '" & Request.Form("Title") & _
"', '" & Replace(Request.Form("Message"), "'", "''") & "')"
conn.Close
Set conn = Nothing
Output by changing conn.Execute to Response.Write:
Code:
INSERT INTO Forum (ReplyTo, DatePosted, TimePosted, PostedBy, Title, Message) VALUES (0, '10/23/2003', '5:11:28 PM', '', 'The quick brown fox', 'The quick brown fox jumps over the lazy dog.')
What does this error mean, and how do I overcome it??? Pls help!
[Thanks in advance|Hope I helped you]
Exodus300