Problem in Update Statement

Posted on 2009-12-31
Last Modified: 2012-05-08
Hello experts, i am trying to update a record in my Access 2003 database through ASP.
it is giving error.
my asp page (vb script) and error message shown by server are given below,
please help, whats the problem.

      <!-- #INCLUDE FILE="" -->
      dim SQL
      set Con = Server.CreateObject("ADODB.Connection")
      Con.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source='C:\Documents and Settings\Administrator\Desktop\ASP Work\Database\Studs.mdb'"
      sql="Update Student SET Class ='abc' where rollno = 101"
      response.write sql
      Con.execute sql       'This is Problem (line no 13)

      'response.write(" Ok")
      response.expires = -1

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/aspwork/updaterecord2.asp, line 13
Question by:soodsandeep

    Author Comment

    table name is Student,
    it has many filelds like Rollno, name, class, sex etc.
    i mean, i have written filed names correct in Update statement.
    LVL 31

    Accepted Solution

    take a read of it has helped me out with this sort of problem many times
    LVL 9

    Expert Comment


    Give everyone read, write and modify permission to this database and the issue gets resolved for you.

    If using pages the provide network services read, write and modify permission to web directory to resolve this issue.


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    What is an ISAPI filter?   •      It's an assembly (.dll file) that can add or change the way IIS works.   •      They can be enabled globally for your web server or on a site-by-site basis.   When the IIS server receives a request, enabling the ISAPI fi…
    This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now