Professional Web Applications Themes

error '80004005'; Operation must use an updateable query. - ASP Database

Are the users logging in with NT authentication? If so, the users will need the NTFS permissions on the mdb as opposed to the IUSR account. Ray at work "Gary D. Rezek" <Gary_RezekNOSPAMsdstate.edu> wrote in message news:OQtlbGfUDHA.2156TK2MSFTNGP11.phx.gbl... > Hi All, > > Microsoft OLE DB Provider for ODBC Drivers error '80004005' > [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. > /ResearcherStaffAwardGeneralHandler.asp, line 142 > > A person logs in and > I've given IUSR_XX Full Control over the .mdb...

  1. #1

    Default Re: error '80004005'; Operation must use an updateable query.

    Are the users logging in with NT authentication? If so, the users will need
    the NTFS permissions on the mdb as opposed to the IUSR account.

    Ray at work

    "Gary D. Rezek" <Gary_RezekNOSPAMsdstate.edu> wrote in message
    news:OQtlbGfUDHA.2156TK2MSFTNGP11.phx.gbl...
    > Hi All,
    >
    > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    > [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
    query.
    > /ResearcherStaffAwardGeneralHandler.asp, line 142
    >
    > A person logs in and
    > I've given IUSR_XX Full Control over the .mdb

    Ray at Guest

  2. #2

    Default Re: error '80004005'; Operation must use an updateable query.

    Hi Ray,
    No, I'm not using NT authentication. This db will be presented to the "outside" world and not everyone accessing it will have an
    NT account because they are "not really faculty or staff".
    I get to "play" with that authentication mode for my next "trick" ;^).
    Thank you.

    gdr

    "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message news:OslQSMfUDHA.372tk2msftngp13.phx.gbl...
    > Are the users logging in with NT authentication? If so, the users will need
    > the NTFS permissions on the mdb as opposed to the IUSR account.
    >
    > Ray at work
    >
    > "Gary D. Rezek" <Gary_RezekNOSPAMsdstate.edu> wrote in message
    > news:OQtlbGfUDHA.2156TK2MSFTNGP11.phx.gbl...
    > > Hi All,
    > >
    > > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    > > [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
    > query.
    > > /ResearcherStaffAwardGeneralHandler.asp, line 142
    > >
    > > A person logs in and
    > > I've given IUSR_XX Full Control over the .mdb
    >
    >

    Gary D. Rezek Guest

  3. #3

    Default Re: error '80004005'; Operation must use an updateable query.

    Hi All,
    As an addendum to this problem:
    I ended up deleting the Visual InterDev project and all references to it, deleting the IIS folder, ensured that the
    IUSR_MachineName did indeed have the proper permissions and basically set up everything from scratch. I don't know how or why,
    but the things got themselves straightened out and everything seems to be working very smoothly now.
    Thanks to Bob and Ray for their help and comments.

    gdr
    --
    Gary D. Rezek
    University Networking Services
    South Dakota State University


    Gary D. Rezek Guest

Similar Threads

  1. "Operation must use an updateable query".- after conversion to NTFS
    By Aaron [SQL Server MVP] in forum ASP Database
    Replies: 6
    Last Post: August 11th, 10:53 AM
  2. operation must use updateable query
    By Tomas in forum ASP Database
    Replies: 3
    Last Post: June 4th, 05:08 AM
  3. Operation must use an updateable query.
    By Frustrated in forum ASP Database
    Replies: 16
    Last Post: April 13th, 06:25 PM
  4. Operation must use an updateable query Error
    By Ray P. in forum ASP Database
    Replies: 2
    Last Post: November 30th, 05:14 AM
  5. INSERT error :: Updateable query?
    By jason in forum ASP
    Replies: 6
    Last Post: August 9th, 08:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139