Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Web Development
  3. ASP.NET
  4. Not able to update data in access db

Not able to update data in access db

Scheduled Pinned Locked Moved ASP.NET
databasehelpwindows-adminannouncementlounge
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R Offline
    R Offline
    Runar
    wrote on last edited by
    #1

    It is not a problem to view data in a datagrid. But when it comes to write to my access db, I get errormessage: System.Data.OleDb.OleDbException: Operation must use an updateable query. I checked the write permission in IIS. But have some problems to understand the properties to my db folder in explorer, under properties I can see in the General tab that there is a read-only attribute that is checked. When I try to uncheck the read-only attribute it seems ok, but if I get back to properties I can see that there was no changes. Please help.

    P G 2 Replies Last reply
    0
    • R Runar

      It is not a problem to view data in a datagrid. But when it comes to write to my access db, I get errormessage: System.Data.OleDb.OleDbException: Operation must use an updateable query. I checked the write permission in IIS. But have some problems to understand the properties to my db folder in explorer, under properties I can see in the General tab that there is a read-only attribute that is checked. When I try to uncheck the read-only attribute it seems ok, but if I get back to properties I can see that there was no changes. Please help.

      P Offline
      P Offline
      Paul Watson
      wrote on last edited by
      #2

      Have you tried looking at the permissions using Windows Explorer rather? Set Write on the file and the folder (keep the dB in it's own folder for this reason) and see if that helps. Access is a PITA with this, totally nonsensical error message too. regards, Paul Watson Bluegrass South Africa Brian Welsch wrote: "blah blah blah, maybe a potato?" while translating my Afrikaans. Crikey! ain't life grand?

      1 Reply Last reply
      0
      • R Runar

        It is not a problem to view data in a datagrid. But when it comes to write to my access db, I get errormessage: System.Data.OleDb.OleDbException: Operation must use an updateable query. I checked the write permission in IIS. But have some problems to understand the properties to my db folder in explorer, under properties I can see in the General tab that there is a read-only attribute that is checked. When I try to uncheck the read-only attribute it seems ok, but if I get back to properties I can see that there was no changes. Please help.

        G Offline
        G Offline
        Geoff Kushnir
        wrote on last edited by
        #3

        Also, in Windows Explorer make sure the correct account has write permissions. In traditional ASP, by default it was the IUSR_...acount. With .NET the deafult is the ASPNET account. Just because I don't care, doesn't mean I don't understand. - Homer J. Simpson

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups