By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,403 Members | 855 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,403 IT Pros & Developers. It's quick & easy.

error when using update query

P: n/a
Hello,
I am doing a bmw tracking project for school using asp and access2000.
on my search.asp page, I can search for a particular bmw and order it if
i want. It works fine when i do select query to get data. But when I try
to order a bmw(using update query), it gives me this message error:
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/bmw/search.asp, line 257

I have gone in to set IIS permission status to both read/write and
change everything that seemed obvious. but i still get this same error
message. Thank you in advance for anyone that can help me.

thank you,
JImm

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"Jimmy Tran" wrote ...
But when I try
to order a bmw(using update query), it gives me this message error:
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/bmw/search.asp, line 257


Hi Jim,

please post your SQL statement(s)..

Regards

Rob
Jul 19 '05 #2

P: n/a
Give read/write NTFS permissions to IUSR on the directory with the .mdb
file.

Ray at work

"Jimmy Tran" <hu*******@yahoo.com> wrote in message
news:un**************@TK2MSFTNGP10.phx.gbl...
Hello,
I am doing a bmw tracking project for school using asp and access2000.
on my search.asp page, I can search for a particular bmw and order it if
i want. It works fine when i do select query to get data. But when I try
to order a bmw(using update query), it gives me this message error:
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/bmw/search.asp, line 257

I have gone in to set IIS permission status to both read/write and
change everything that seemed obvious. but i still get this same error
message. Thank you in advance for anyone that can help me.

thank you,
JImm

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #3

P: n/a
You need to have write permissions on the folder you Access database is
in. It has nothing to do with your SQL query.

Andrew

DEVBuilder.org, http://www.DEVBuilder.org
ASP,ASP.NET,VB.NET,PHP,Java,and SQL Support, all in one place.
Jul 19 '05 #4

P: n/a
http://www.aspfaq.com/2062

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"Jimmy Tran" <hu*******@yahoo.com> wrote in message
news:un**************@TK2MSFTNGP10.phx.gbl...
Hello,
I am doing a bmw tracking project for school using asp and access2000.
on my search.asp page, I can search for a particular bmw and order it if
i want. It works fine when i do select query to get data. But when I try
to order a bmw(using update query), it gives me this message error:
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/bmw/search.asp, line 257

I have gone in to set IIS permission status to both read/write and
change everything that seemed obvious. but i still get this same error
message. Thank you in advance for anyone that can help me.

thank you,
JImm

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #5

P: n/a
here's part of the code, thx

Case "editsave"
' Part 2 of 2: Here's where we save the values that the
' user entered back to the DB. Again... no error
' handling or input checking so ' characters and invalid
' values will throw error messages.
iRecordId = Request.Form("id")
iRecordId = Replace(iRecordId, "'", "''")

' Date delimiter on this should be changed to # for Access
strSQL2 = "UPDATE car SET stat= 'O' WHERE (id = " & iRecordId & ")"
'strSQL2 ="select * from car where id = "& iRecordID &""

response.write strSQL2
Set rstSearch = cnnSearch.Execute(strSQL2)
cnnDBEdit.Close

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.