error when using update query

[Jimmy Tran]

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!

[Rob Meade]

"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

[Ray at]

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!

[Andrew Durstewitz]

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.

[Aaron Bertrand - MVP]

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!

[Jimmy Tran]

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!