title: CLASSIC ASP: INSERTING A RECORD
body: <p>First my apologizes for my poor english.
  I'm trying insert a new record in a table (tblComentarios)</p>
  
  <p>This is the code i'm using</p>
  
  <pre><code>conn.Provider = "Microsoft.Jet.OLEDB.4.0"
  
  conn.Open "C:\Users\VilaNova\Documents\aspirador\guestbook.mdb"
  
  sql = "INSERT INTO tblComentarios (nome,comentario) "
  
  sql = sql &amp; "VALUES ('john', 'good job');"
  
  on error resume next
  
  conn.Execute sql, recaffected
  
  if error &lt;&gt; 0 then
  
     response.write "No permissions!"
  
  else
  
     response.write "added record!"
  
  end if 
  </code></pre>
  
  <p>When i execute the code i get no errors and i get the message "added record"
  But, when i open de database and see the table's contents there is no
  record with the values 'john' and 'good job'</p>
  
  <p>Thanks for any help.</p>