Microsoft JET Database Engine error '80004005'

[accuransx]

My codes run ok in my local PC but when I upload to my server, i got this error:

Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.

/ZigUpdateStatus.asp, line 39



Can anybody explain this? These are my codes:

set conn=Server.CreateObject("ADODB.Connection&quot
conn.Provider="Microsoft.Jet.OLEDB.4.0"
stropen= server.MapPath("PasarApplicant.mdb&quot
conn.Open stropen
strsql="UPDATE unitlist SET name='" & namaorang & "',nric='" & nricorang & "',status= '" & Request.Form("cars&quot & "' WHERE unitno='" & Request.Form("fLotNo&quot & "'"
' how to update multiple fields
set rs=conn.Execute(strsql)
'set rs=conn.Execute strsql
Response.Redirect "zigStatus.asp"

 

[culshaja]

Have you checked you have write permission on the directory that you have the database in on the server. Most ISPs only allow write access on certain directories for security reasons.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[accuransx]

Thanks...now my code is just fine...

 

[Deadline]

Hi,
What is the status of your problem ? Can you share with us how did you fix it ?


Thank you.
RR.

 

[Guest_imported]

thx james thx very much for the tip love u