title: MS Access Alter Statement: change column data type to DATETIME
body: <p>I have a column named as <code>recordTime</code> in my Access DB table <code>table1</code>. </p>
  
  <p>This column is of <code>TEXT</code> type right now, and most of its value are in format as: <code>yyyy-mm-dd hh:nn:ss</code>, but there are also some wrong records like this: <code>yyyy-mm- ::</code>. </p>
  
  <p>Now I would like to change the data type of this column from <code>TEXT</code> to <code>DATETIME</code>. I tried with the following query but nothing happens: </p>
  
  <pre><code>             ALTER TABLE table1
               ALTER COLUMN recordTime DATETIME;
  </code></pre>
  
  <p>Am I doing it wrong?</p>