title: Access database Connection string error in asp
body: <p>I have created an asp feedback web page this page connect with the access database
  when I run this page every thing is ok until I click to submit button
  When I click submit button it gives error like</p>
  
  <p>and here is my asp code</p>
  
  <pre><code>&lt;%   
  DIM objConn
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn.ConnectionString =Provider=Microsoft.Jet.OLEDB.4.0;
   Data Source="Server.MapPath("/MyData.mdb")
  
  objConn.Open
  %&gt;
  &lt;%
  DIM objRS
  Set objRS = Server.CreateObject("ADODB.Recordset")
  objRS.Open "tblContact",objConn,adLockOptimistic,adCmdTable
  objRS.AddNew
  objRS("Email") = Request.Form("Email")
  objRS("FirstName") = Request.Form("FirstName")
  objRS("LastName") = Request.Form("LastName")
  objRS("Comments") = Request.Form("Comments")
  objRS("DateContacted") = Date()
  objRS.Update
  %&gt;
  
  &lt;%
  DIM strFirstName
  strFirstName = Request.Form("FirstName")
  %&gt;
  
  &lt;%
  objRS.Close
  Set objRS = Nothing
  objCONN.Close
  Set objCONN = Nothing
  %&gt; 
  </code></pre>