title: CREATE TABLE IF NOT EXISTS throws an error in UCanAccess
body: <p>Instead of using MySQL xampp server on my Java project, I decided to use Microsoft Access as my database but I got an error in my query using this syntax. Here is my Java code</p>
  
  <pre><code>public static void main(String[] args) throws SQLException {
          // TODO code application logic here
          try {
              conn = DriverManager.getConnection("jdbc:ucanaccess://C:\\Database.accdb;jackcessOpener=myproject.CryptCodecOpener","root", "");
              System.out.println("successfuly connected");
              Statement s = conn.createStatement();
              PreparedStatement state = conn.prepareStatement("CREATE TABLE IF NOT EXISTS test(name varchar(400))");
              state.executeUpdate();
  
  } catch (SQLException e) {
  e.printStackTrace();
  }
       finally {
  
          }
  </code></pre>
  
  <p>Here is the error:</p>
  
  <pre><code>net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.1 user lacks privilege or object not found: IF
      at net.ucanaccess.jdbc.UcanaccessPreparedStatement.executeUpdate(UcanaccessPreparedStatement.java:256)
      at myproject.MyProject.main(MyProject.java:31)
  </code></pre>
  
  <p>Using <code>IF NOT EXISTS</code> in MySQL works fine, but in UCanAccess I got that error and if I remove the <code>IF NOT EXISTS</code> it works fine.</p>