title: UCanAccess error: user lacks privilege or object not found: WHERE
body: <p>I am currently trying to update a record using Java Netbeans into a MS Access Database and i keep on getting the following error:</p>
  
  <pre><code>ERROR: net.ucanaccess.jdbc.UcanaccessSQLException: user lacks privilege or object not found: WHERE
  </code></pre>
  
  <p>The following is my code:</p>
  
  <pre><code>public void Edit(Customer a, int id) {     
      con = DBConnect();
  
      String sql = "Update Customer set CName =?,CAge =?,CPhone =?,CAddress =?, CGender =?, WHERE [ID] =" + id + "";
  
  
      try {
          s = con.prepareStatement(sql);
          s.setString(1, a.getName());
          s.setString(2, a.getAge());
          s.setString(3, a.getContact());
          s.setString(4, a.getAddress());
          s.setString(5, a.getGender());
  
          s.executeUpdate();
          JOptionPane.showMessageDialog(null, "Customer profile Updated");       
  
      } catch (Exception e) {
          JOptionPane.showMessageDialog(null, e);
      }
  }
  </code></pre>