title: OleDbCommand: SQL syntax error
body: <p>I am having trouble with a ALTER TABLE command that I am trying to use on a MS Access database in a C# project. I am trying to rename a column and change the type at the same time.</p>
  
  <p>Here is my command:</p>
  
  <pre><code>string sqlCommand = "ALTER TABLE " + tableName + " CHANGE [" + oldColName + "] [" 
      + newColName + "] " + colType;
  </code></pre>
  
  <p><strong>What is wrong in this command and what do I need to do to make this it work?</strong></p>
  
  <hr>
  
  <h2>*Edits:</h2>
  
  <p>-The type and the names of the table, new column and old column are not the problem!</p>
  
  <p>-The exception that is catched is :</p>
  
  <blockquote>
    <p>Syntax error in ALTER TABLE statement.</p>
  </blockquote>
  
  <p>-The final string looks like this:</p>
  
  <blockquote>
    <p>ALTER TABLE [Big List] CHANGE [num] [test] CHARACTER</p>
  </blockquote>
  
  <p>-Connection provider:</p>
  
  <blockquote>
    <p>Microsoft.ACE.OLEDB.12.0</p>
  </blockquote>