Help I Can't update a Access database with the following code any sugestions thanks in advance.
Set Conn = Server.CreateObject("ADODB.Connection"
Conn.ConnectionString= "DRIVER={MICROSOFT Access Driver (*.mdb)}; DBQ=C:\Inetpub\Conn.Open
Set rstProducts = Server.CreateObject("ADODB.RecordSet"
rstProducts.Open "Products", Conn, 3 ,3
rstProducts.AddNew
rstProducts("ProductName" = Request.Form("ProductName"
rstProducts("UnitPrice" = Request.Form("UnitPrice"
rstProducts("ReorderLevel" = Request.Form("ReorderLevel"
rstProducts("LeadTime" = Request.Form("LeadTime"
rstProducts.Update
Conn.Close
Set conn = nothing
rstProducts.Close
Set rstProducts = nothing
Set Conn = Server.CreateObject("ADODB.Connection"
Conn.ConnectionString= "DRIVER={MICROSOFT Access Driver (*.mdb)}; DBQ=C:\Inetpub\Conn.Open
Set rstProducts = Server.CreateObject("ADODB.RecordSet"
rstProducts.Open "Products", Conn, 3 ,3
rstProducts.AddNew
rstProducts("ProductName" = Request.Form("ProductName"
rstProducts("UnitPrice" = Request.Form("UnitPrice"
rstProducts("ReorderLevel" = Request.Form("ReorderLevel"
rstProducts("LeadTime" = Request.Form("LeadTime"
rstProducts.Update
Conn.Close
Set conn = nothing
rstProducts.Close
Set rstProducts = nothing