Operation must use an updateable query RRS feed

  • Question

  • Hi Dear,

    I am working an asp application and using ms-access data base..

    when i insert/update and delete any record then find this error.

    Error Is:

    Microsoft JET Database Engine error '80004005'

    Operation must use an updateable query.

    /newsletter/common/proccess.asp, line 62

    I have all permission on data base(read/write permission)

    Please help me.


    Yogesh Saini

    Tuesday, March 25, 2008 6:54 AM


All replies

  • Sounds like there is still a permissions problem. It isn't clear whether you are working on this application locally or on a network server so some additional information would be helpful. You could also take a look at the following MS KB article:


    An unhandled exception may occur when you try to connect to an Access database from an ASP.NET worker process


    If you're using Windows 2003 or later then the default account is NetworkService and not ASPNET.

    Tuesday, March 25, 2008 1:16 PM
  • Hi Sir,
    I am working on server.
    by administrator provide all permission to database.

    Please help me.


    Yogesh Saini
    Wednesday, March 26, 2008 4:04 AM
  • I need some more information:


    Which server operating system are you using?

    What level of authentication is your application configured for (Anonymous? Basic? Integrated NT?)

    Is your application configured for impersonation?

    Is the Access database located on the web server or another server?


    Wednesday, March 26, 2008 11:40 AM
  • The error could be related to the fact that some of the column names or table names in your SQL statements are reserved words. For example, in following INSERT SQL statement name of the table is Name and name of the column is Date


    INSERT INTO Name (Date) VALUES (SomeDateValueHere)


    Since those names are reserved key words, provider could fail to parse statement properly. To solve this issue, you need to add square brackets around names, like


    INSERT INTO [Name] ([Date]) VALUES (SomeDateValueHere)


    but ideally you should avoid using reserved words and database object names.


    Wednesday, March 26, 2008 11:43 AM