1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

'Operation must use an updateable query ERROR!

Discussion in 'C#' started by ilisoft, Jul 6, 2006.

  1. #1
    web = ddloc & "file.mdb"
    connstring = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath(web)
    set db=server.createobject("ADODB.connection")
    db.open connstring

    this is the code to connect! These are the things that I already did:

    - IUSR + IWAM has modify on mdb + mdb folder + tmp folder
    Changed security in IIS to write

    I still receive:
    SEMrush

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

    Can someone help me out
     
    ilisoft, Jul 6, 2006 IP
    SEMrush
  2. tanfwc

    tanfwc Peon

    Messages:
    579
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #2
    tanfwc, Jul 6, 2006 IP
  3. ilisoft

    ilisoft Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thnx for your reply but still nothing. I gave users write permission to the mdb + mdb folder

    GRRRRRRRRRRRRRR.
     
    ilisoft, Jul 6, 2006 IP
  4. draculus

    draculus Peon

    Messages:
    63
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #4
    The problem is with the sql query, not permissions.

    You will need to supply the query to identify the problem.
     
    draculus, Jul 7, 2006 IP
  5. ilisoft

    ilisoft Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Problem solved!

    Permissions! Deleted the mdb folder and recreated in an other folder.
    Set the permissions.
    Everything ok, now.
     
    ilisoft, Jul 7, 2006 IP