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

 

[Guest_imported]

The connection string is not right. Here is an example:

path = server.MapPath("/fluidsman/fluidsman.mdb&quot
connectme = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& path &";"
Conn.Open connectme

 

[hdougl1]

Thanks a lot for the suggestion, I'm getting another error now "Cannot update. Database or object is read-only." pointing to the line rstProducts.AddNew I've recreated the Access database insuring there are no passwords or security settings in place. I’ve been trying several different DSN less connections, and that was my last failure to connect and add a new record.

 

[BlastRadius]

I always use the code below, always puting the metadata type include at the top of the page. I also always asign the form values to varibles. Hope this helps!


<!-- METADATA TYPE=&quot;typelib&quot;
FILE=&quot;C:\Program Files\Common Files\System\ado\msado15.dll&quot; -->
accessdb=server.mappath(&quot;access.mdb&quot
strconn=&quot;PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=&quot;
strconn=strconn & accessdb & &quot;;&quot;
'&quot;strconn=&quot;uid = l; pwd = l&quot;

set conntemp=server.createobject(&quot;ADODB.Connection&quot
conntemp.open strconn
set rstemp=server.createobject(&quot;ADODB.Recordset&quot
rstemp.open &quot;tablename&quot;, conntemp, adForwardOnly, adLockPessimistic, adCmdTable