title: Error when inserting a record into MS Access
body: <p>I have val <code>MyDate</code> in my C# program that contain <strong>today-date</strong> or <strong>null</strong>.</p>
  
  <p>I have date field in my access 2007 -  <code>TdateOpen</code></p>
  
  <p>I try to insert to the database like this: </p>
  
  <pre><code>SQL = "insert into MyCount(TdateOpen) values ('" + MyDate +"')";
  </code></pre>
  
  <p>and I get this error:</p>
  
  <pre><code>Data type mismatch in criteria expression
  </code></pre>
  
  <p>what can be the problem?</p>