title: ASP DataConnectivity Error
body: <p>I am a Student and ASP is my subject this year. I am trying to do the Database Connectivity for the First time. It gave me this Error while i was connecting my ASP file with MSAccess.
  Code:  
  </p>
  
  <pre><code>&lt;% 
  Dim objConn, strConn, objRS
  Set objConn = Server.CreateObject("ADODB.Connection")
  strConn = "PROVIDER=Microsoft.ACE.OLEDB.12.0;DATA SOURCE =" &amp; _
   "C:\demo.accdb"
  objConn.Open strConn
  Set objRS = Server.CreateObject("ADODB.Recordset")
  objRS.Open "Student", objConn, 2, 2
  objRS.AddNew
  objRS("idnum") = Request.Form("idnum")
  objRS("firstname") = Request.Form("firstname")
  objRS("lastname") = Request.Form("lastname")
  objRS.Update
  objRS.close
  %&gt;
  </code></pre>
  
  <p>
  **The Above code Gives the Following Error:*
  ADODB.Recordset error '800a0cc1'
  Item cannot be found in the collection corresponding to the requested name or ordinal.
  /MyWeb/choice1.asp, line 12*
  .. I also tried doing this..
  ..
  ..</p>
  
  <pre><code>Dim objConn, strConn, objRS
  Set objConn = Server.CreateObject("ADODB.Connection")
  strConn = "DSN=Stud"
  objConn.Open strConn
  </code></pre>
  
  <p>and it gives me the same error.
  My Database name is demo.accdb
  My Table name is Student.
  ApplicationPool Settings for IIS is set to "true" for using Windows 32bit.
  I have also installed OLEDB ACE 12.</p>
  
  <p>Please help as am totally in mess.. All I want is to insert a record in an Access Database.
  Help would be appreciated.</p>