'Operation must use an updateable query ERROR!

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

0
  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:


    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
  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