I keep getting this error whenever I run my ASP page.

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

The line of error is where I INSERT values on the database.

I've resarched about this error in the internet but I can't seemt o find the answer. The Folder where the database is located have Read/Write/Modify permision to the users. Also the database itself has the same permission. But still I get the same error. I don't know what to do anymore...

I hope somebody can help me in here...

By the way, sorry if I had to start a new topic, I can't seemt o find where I can squeeze this one... :D

Thanks ion advance and have a nice day!

I also want to add as question:

Where can I configure IUSR Account? is it the account of each user of the program? Where can I configure it?

try to print the insert/update statement and run it on backend and check whether it inserts there, if its working, there is something wrong in the code else you can check where the problem is in the back-end.

I didnot get your second question?

Regards

sinapra

My query worked out fine...but I still can't figure out what's wrong with my code...

I have the code below..

if inStr(1,UserName,".") = 0 then

    tym = time()

    d8 = date()

    Fullname = Username

    set con = Server.CreateObject("ADODB.Connection")

    con.Provider="Microsoft.Jet.OLEDB.4.0"

    con.Open Server.Mappath("NewsDB.mdb")

    strValues = " '"&Fullname&"', '"&d8&"', '"&tym&"', '"&readers&"' "

    SQL = "Insert into Visitors (VisitorName, DateOfVisit, TimeOfVisit, VisNum) values ("&strValues&") "

' response.write sql

    con.Execute(SQL)

else...

Hi,

  Make sure your MDB file is not Read Only. Or you dont have sufficient privelege to insert/update/delete.

Hi already got it...It was not about the priviledge to write/update/delete coz I was having Full control of the file. As sinapra suggested, it was on the query. I had to configure something in the IIS to solve my problem...anyway...thanks for the Help and thank you for taking the pains to answer my questions.

Although I have another question that I can't seem to find the problem...

First...the error is...
>Microsoft JET Database Engine error '80040e07'
>Datatype mismatch in criteria expression.

My code is the following...

<% SQL = "Select Distinct Department, WebPage from NewsDatabase where Volume = "&vol&" and Status = 'Released'"

        set rsSection = con.Execute(SQL)

    'Response.Write sql

    dCtr = 0

    while not rsSection.EOF

        dCtr = dCtr + 1

        'Response.write rsSection("WebPage") & " <br> "

        rsSection.Movenext

    wend

        'Response.Write dCtr

        rsSection.MoveFirst

    For j = 1 to dCtr

    web = rsSection("WebPage")
    dep = rsSection("Department")

    if dep = "Finance and Administration" then

--> dep = "Fin. Admin. Pur. IT"

    end if
%>


The one with the arrow is where the error points...

Hope you could still help me with one..Thanks in advance! :D

I am not sure if that line returns error. Also not sure what you are trying to do here... which you could do within the WHILE loop above. Can you explain a bit on that?
Cheers!

_________________________
- Vijay G
Strive for Perfection