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
  1. Home
  2. Web Development
  3. No database wants to work

No database wants to work

Scheduled Pinned Locked Moved Web Development
databasecsharpdotnetsysadminhelp
5 Posts 2 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.
  • E Offline
    E Offline
    evlxtc
    wrote on last edited by
    #1

    SERIOUS... Lost all my sites. I have been working on a few ACCESS DATABASE websites and all was working fine....TILL NOW. All of my sites on my local machine is giving me exactly the same error when ever I try to access my ACCESS DBs. All different sites, all with different databases.... What is going on. .PLEASE. Here is the error. This funnely enough happened just after I did an ASPX page connection to an Access DB and from there on all my ASP page connections to ANY OTHER DB in ANY of my other sites fell over.. DISASTEROUS. PS Working in Dreamweaver MX. The part that bothers me is "Operation must use an updateable query." FULL ERROR. ----------------- Please try the following: • Click the Refresh button, or try again later. • Open the localhost home page, and then look for links to the information you want. HTTP 500.100 - Internal Server Error - ASP error Internet Information Services ________________________________________ Technical Information (for support personnel) • Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /gkd/CandidateScoreWOL.asp, line 111 • Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) • Page: POST 195 bytes to /gkd/CandidateScoreWOL.asp • POST Data: cWORK=6&cPARTNER=0&cCHILDREN=0&cFAMILY=0&cRELIGION=0&cHOBBIES1=0&cHOBBIES2=0&cHEALTH=0&cSPORT1=0&cSPORT2=0&cFINANCIALINDEPENDANCE=0&cOTHER1=0&cOTHER2=0&Submit=Submit&MM_update=form1&MM_recordId=1 • Time: Monday, January 09, 2006, 1:37:56 PM • More information: Microsoft Support ---------------------------------------------------- this is me

    G 1 Reply Last reply
    0
    • E evlxtc

      SERIOUS... Lost all my sites. I have been working on a few ACCESS DATABASE websites and all was working fine....TILL NOW. All of my sites on my local machine is giving me exactly the same error when ever I try to access my ACCESS DBs. All different sites, all with different databases.... What is going on. .PLEASE. Here is the error. This funnely enough happened just after I did an ASPX page connection to an Access DB and from there on all my ASP page connections to ANY OTHER DB in ANY of my other sites fell over.. DISASTEROUS. PS Working in Dreamweaver MX. The part that bothers me is "Operation must use an updateable query." FULL ERROR. ----------------- Please try the following: • Click the Refresh button, or try again later. • Open the localhost home page, and then look for links to the information you want. HTTP 500.100 - Internal Server Error - ASP error Internet Information Services ________________________________________ Technical Information (for support personnel) • Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /gkd/CandidateScoreWOL.asp, line 111 • Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) • Page: POST 195 bytes to /gkd/CandidateScoreWOL.asp • POST Data: cWORK=6&cPARTNER=0&cCHILDREN=0&cFAMILY=0&cRELIGION=0&cHOBBIES1=0&cHOBBIES2=0&cHEALTH=0&cSPORT1=0&cSPORT2=0&cFINANCIALINDEPENDANCE=0&cOTHER1=0&cOTHER2=0&Submit=Submit&MM_update=form1&MM_recordId=1 • Time: Monday, January 09, 2006, 1:37:56 PM • More information: Microsoft Support ---------------------------------------------------- this is me

      G Offline
      G Offline
      Guffa
      wrote on last edited by
      #2

      The error message means that the user account used for running the asp code doesn't have write permission to the database file. Check in the properties for the web site, what user account is used for anonymous access (installing .NET might change this), then check the permissions on the database file for that account. --- b { font-weight: normal; }

      E 2 Replies Last reply
      0
      • G Guffa

        The error message means that the user account used for running the asp code doesn't have write permission to the database file. Check in the properties for the web site, what user account is used for anonymous access (installing .NET might change this), then check the permissions on the database file for that account. --- b { font-weight: normal; }

        E Offline
        E Offline
        evlxtc
        wrote on last edited by
        #3

        I am using XP... HOW do I do this... I have checked and my IIS is using IUSER_ what ever as the authentication user account but how do I check my files to see that they also have this?? Sorry sounds dumb I am sure.. PLEASE HELP... And YES it all happened after I installed .NET Framework. DAMN why don't they TELL you this will happen when you install it. :( THANKS for the feedback thus far. this is me

        1 Reply Last reply
        0
        • G Guffa

          The error message means that the user account used for running the asp code doesn't have write permission to the database file. Check in the properties for the web site, what user account is used for anonymous access (installing .NET might change this), then check the permissions on the database file for that account. --- b { font-weight: normal; }

          E Offline
          E Offline
          evlxtc
          wrote on last edited by
          #4

          I have got .NET and my IIS running on a XP machine. WHERE do I check my security on the FILES. In IIS it is using the IUSER_ what ever account to gain access... Thanks for the help thus far, I just need to know now WHERE to check and HOW to check all this. THANKS FOR A GR8 WEBSITE AND EXTREMELY HELPFULL AND QUICK SUPPORT. Why don't they tell you .NET Framework will MURDER all your sites... :( ;) this is me

          G 1 Reply Last reply
          0
          • E evlxtc

            I have got .NET and my IIS running on a XP machine. WHERE do I check my security on the FILES. In IIS it is using the IUSER_ what ever account to gain access... Thanks for the help thus far, I just need to know now WHERE to check and HOW to check all this. THANKS FOR A GR8 WEBSITE AND EXTREMELY HELPFULL AND QUICK SUPPORT. Why don't they tell you .NET Framework will MURDER all your sites... :( ;) this is me

            G Offline
            G Offline
            Guffa
            wrote on last edited by
            #5

            Why do you post two different replies with the same contents? And why oh WHY do you CAPITALIZE every other WORD that YOU are WRITING? Right click on the file in explorer and open the properties for the file. Go to the security tab. There you will see the accounts that have permissions set for the file. --- b { font-weight: normal; }

            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