Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Unanswered: insert into db error

    Hi !

    When i try to insert some values into an access db it gives me back this error :

    **********************
    Tipo de error:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][Controlador ODBC Microsoft Access] La operación debe usar una consulta actualizable.


    in english something like ... " you must use an updatable query .... "

    *************************

    if tried everythong but i can't work it out . Any help ?

    thankx !!

    this is the code


    <%
    auname=request.form("nom")
    auyear=request.form("tf")
    auID=request.form("fax")


    Set Cnn = Server.CreateObject("ADODB.Connection")
    strConAccess = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Inetpub\wwwroot\interiorisme\bd_in teriorisme.mdb"
    Cnn.open StrConAccess

    SQLStmt = "INSERT INTO tbl_empresa2 (nom,descripcio) VALUES ('sadsadasd','dfsdfsdf')"
    Set RS = cnn.Execute(SQLStmt)
    set rs=nothing

    Conn.Close
    set conn=nothing
    %>

  2. #2
    Join Date
    Dec 2003
    Posts
    454
    What is the exact meaning?

    La operación debe usar una consulta actualizable

  3. #3
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    A quick search of google revealed its a MDAC problem;

    The latest MDAC drivers (anything in the past six months), and especially the Access ODBC driver, have a "feature" that REQUIRES a SYSTEM temp variable be establised. This is done from right clicking My Computer, choosing Properties, Environment, and adding the system variables of TMP C:\TEMP and TEMP C:\TEMP.
    You may need to get your host to update the drivers.

  4. #4
    Join Date
    Dec 2003
    Posts
    5

    thanks

    Thanks very much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •