none
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.



    Thanks


    Yogesh Saini



    Tuesday, March 25, 2008 6:54 AM

Answers

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.


    Thanks

    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
    Moderator