error type:Microsoft JET Database Engine.......and error 80020009

[desconi]

Hi,
I would like to ask for help. I'm a beginner in this field....and really don't know how to solve the problem, besides that i didn't write the codes. they were written by my ex-colleague.
I'll try to explain what the problem is:
He made an upload form-called Newsentrya.asp.I installed and configured a virtual server IIS ver.5.1 my OS is XP Prof Ver 2002 ServPack3 and the form works without any problems but at the office i did the same cause i need a testing server for the ASPs but i have problem it gives me an error:

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/bg/Newsentrya.asp, line 69 For Each File In Uploader.Files.Items
File.SaveToDisk f
if fpath="--" then
fpath=fpath & "," & "\NewsAttachments\" & Number & File.FileName
else
fPath= "\NewsAttachments\" & Number & "\" & File.FileName
end if
next
end if
sql="insert into news_details(numNumber,dtNewsDate,txtHeadline,txtNews,dtStartDate,dtEndDate,picture)
values('"&number&"',date(),'"&txtHeadline&"','"&txtnewstext&"','"&txtkdate&"','"&txtedate&"','"&fpath&"')"
(this is line 69!) con.Execute sql
Response.Write "<font color=red face=safon size=4><b>Data is Succesfully added</font>"

Response.Write "<font color=red face=safon size=4><b>Data is Succesfully added</font>"

and

POST Data:
error '80020009'
Exception occurred.

/iisHelp/common/500-100.asp, line 223
If strMethod = "POST" Then
Response.Write Request.TotalBytes & " bytes to "
End If

Response.Write Request.ServerVariables("SCRIPT_NAME")

lngPos = InStr(Request.QueryString, "¦")

If lngPos > 1 Then
Response.Write "?" & Server.HTMLEncode(Left(Request.QueryString, (lngPos - 1)))
End If

Response.Write "</li>"

If strMethod = "POST" Then
Response.Write "<p><li>POST Data:<br>"
If Request.TotalBytes > lngMaxFormBytes Then
(this is line 223!)Response.Write.Server.HTMLEncode(Left(Request.Form, lngMaxFormBytes)) & " . . ."
Else
Response.Write Server.HTMLEncode(Request.Form)
End If
Response.Write "</li>"
End If

But the main problem is that on the live server - Win Server 2003 and IIS ver 6.0 and form sometimes works sometimes don't. Pls, help me to solve this problem.

[edited by: phranque at 6:47 am (utc) on July 20, 2008]
[edit reason] fix line width [/edit]

[phranque]

welcome to WebmasterWorld [webmasterworld.com], desconi!

have you had any luck solving this problem?

[httpwebwitch]

That error is almost always a permissions problem. Make sure the user doing the query (it may be a user called ASPNET) has write permissions in the database.