Connection to MDB ???

[ASPVB]

People ! Does somebody know the answer for my problem :
I write little site and using Microsoft Access DataBase.
I have 2 examples of connection string to my DB.

CONNECT_1 = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & Server.MapPath("/AD/spl/Script/AD.mdb&quot
CONNECT_2 = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("/AD/spl/Script/AD.mdb&quot & ";"

Both of them work when I take Recordsets(even complicated)!
===========================================================
But I try to Execute Insert or Update SQL-statment :

set cn=Server.CreateObject("adodb.connection&quot
cn.open CONNECT_1

cn.Execute "Insert Into Theme (Descr) Values ('" & nTmp & "')"

I get an error : Microsoft Jet Database Engine (0x800004005)
Operation must use an Updateable query .
-----------------------------------------------------------
set cn=Server.CreateObject("adodb.connection&quot
cn.open CONNECT_2

cn.Execute "Insert Into Theme (Descr) Values ('" & nTmp & "')"

I get an error : Microsoft OLE DB Provider for ODBC Drivers (0x800004005)
[Microsoft][ODBC Microsoft Access Drivers]
Operation must use an Updateable query .

 

[Smarty]

I use this and it works. I guess you have to set it equal to a recordset. It will contain the error code on failure I believe (but that I'm not sure of...)
declarations:
dim conn
dim rs, rs2
Set Conn = Server.CreateObject("ADODB.Connection&quot
' conn.close
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Data\products.mdb&quot

update query:
ssql= "update domeinen set d_naamfr = '" & request("domfr&quot & "' where id_domein = "& request("domid&quot
set rs2 = conn.execute(ssql)

 

[ASPVB]

Sorry Smarty !
It's doesn't help.