Help I Can't update a Access database

[hdougl1]

Help I Can't update a Access database with the following code any sugestions thanks in advance.

Set Conn = Server.CreateObject("ADODB.Connection&quot
Conn.ConnectionString= "DRIVER={MICROSOFT Access Driver (*.mdb)}; DBQ=C:\Inetpub\

http://wwwroot\fluidsman\fluidsman.mdb"

Conn.Open

Set rstProducts = Server.CreateObject("ADODB.RecordSet&quot
rstProducts.Open "Products", Conn, 3 ,3
rstProducts.AddNew
rstProducts("ProductName&quot = Request.Form("ProductName&quot
rstProducts("UnitPrice&quot = Request.Form("UnitPrice&quot
rstProducts("ReorderLevel&quot = Request.Form("ReorderLevel&quot
rstProducts("LeadTime&quot = Request.Form("LeadTime&quot
rstProducts.Update
Conn.Close
Set conn = nothing
rstProducts.Close
Set rstProducts = nothing

 

[DavidAWH]

dont know if it will help but try closing the recordset and setting it to nothing before you close the connection and set it to nothing