Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Operation must use an updeateable query

Status
Not open for further replies.

exodus300

Programmer
Mar 22, 2002
262
AU
Error Type:
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
[pc3]
 
You dont have rights to modify/change database content.
Check the database security properties and be shure that ISUR_computername has the right to change/modify.

________
George, M
 
Duh, so simple... thanks!

[Thanks in advance|Hope I helped you]
Exodus300
[pc3]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top