.addnew with ASP

how do I insert data to me db using .addnew and .update

how must I define my recordset etc.

Ooops!!

Code:

---

<%
Dim objConn, rsRec
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath ("Database.mdb")
Set rsRec = Server.CreateObject("ADODB.Recordset")
rsRec.Open "Table1", objConn, 1, 3
rsRec.AddNew
rsRec("Field1") = Request.Form("txtBox1")
rsRec("Field2") = Request.Form("txtBox2")
rsRec.Update
rsRec.Close
objConn.Close
Set rsRec = Nothing
Set objConn = Nothing
%>

---

Hope this helps!!

You can also specify a DSN in the ODBC icon of the Control Panel. It sometimes is easier but sometimes slower as well.

IT is also a real *****. I would stick with ADO.