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

What is the exact meaning?

La operación debe usar una consulta actualizable

A quick search of google revealed its a MDAC problem;

You may need to get your host to update the drivers.

Thanks very much!