"Operation must use an updateable query." - will happily pay $25 for working solution

Discussion in 'C#' started by norfstar, Feb 27, 2007.

0
  1. #1
    I've taken over management of a website that uses ASP (which I have minimal knowledge of as I'm more a LAMP kinda guy), and the scripts seem to be able to access the database file to fetch its contents fine. However, in the content management system, when trying to add or update anything, I get the following error message:

    From what I can make out from Googling this, such databases need to allow write permission for an internet guest user. I found a tutorial that explains this can be set by clicking the database file properties, then a security tab - however I imagine this is reliant of having some kind of software (Microsoft Access?) on the computer, as this tab doesn't show for me.

    Anyone know of a way I can get this working? It's pretty urgent, as some of the content needs updating immediately and I'll be pleased to pay someone $25 who can get this running. Please PM me if you can do this and I'll sort out an FTP account.
     
    norfstar, Feb 27, 2007 IP
  2. MarkusJ_NZ

    MarkusJ_NZ Well-Known Member

    Messages:
    240
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    108
    #2
    Hi, this is because the folder under where the database resides does not have the correct windows permissions.

    Via Windows you need to give the following person read/ write rights to the folder and the database contained in this folder.

    To do this located the folder where the Access database resides, in Windows Explorer, right click on the folder.

    Go Properties, Security can then click on the "Add" button. Locate the following users NETWORK SERVICE and give the person Read/ Write / Modify Permissions on the folder and files below it.

    If you are running an ASP NET then you need to do the above for ASPNET account as well (Ensure that you check that the location is the machine which hosts your website).

    If you are running 2000 then you will have to do the above for IUSER_MACHINENAME where MACHINENAME is the name of the webserver.

    Hopefully this will get you started
    Regards
    MarkusJ



    You will need to be able to place permissions on the actual folder. Who is your webhosting company?
     
    MarkusJ_NZ, Feb 27, 2007 IP
    norfstar likes this.
  3. norfstar

    norfstar Peon

    Messages:
    1,154
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    0
    #3
    PM sent :).

    The site is currently hosted on GoDaddy, but if it means getting this to work I'll move it to where it is supported.
     
    norfstar, Feb 27, 2007 IP
  4. ludwig

    ludwig Notable Member

    Messages:
    2,253
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    225
    #4
    did you get it fixed?

    its a common problem of an access db
     
    ludwig, Feb 28, 2007 IP
  5. MarkusJ_NZ

    MarkusJ_NZ Well-Known Member

    Messages:
    240
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    108
    #5
    Hi, yes, it's all fixed now :)
     
    MarkusJ_NZ, Mar 2, 2007 IP