Steven Cooke

I have ucanaccess 4.0.4, jackcess 2.1.11 and hsqldb.jar . I was under the impression that these versions supported creation of indexes but I get an error saying its unsupported. Maybe its my syntax although it looks correct to me. I'm using MS Access 2010 This is part of the code st.execute("CREATE TABLE tblTemp (reqno TEXT, technique TEXT)"); System.out.println("tblTemp table created"); When I check the table is there with the columns I expected. I then run this immediatley after st.execute("CREATE...

looks like a syntax error sql = "INSERT INTO table (column1, column2) + " SELECT table2.column1, table2.column2 FROM table.2" + " WHERE some condition exists";

My code looks like this: PreparedStatement ps = null; sql = "SELECT tblRequestsFromDWH.* INTO tblTechnique FROM tblRequestsFromDWH WHERE tblRequestsFromDWH.finalBethesda Is Null AND tblRequestsFromDWH.smearTechnique Is Not Null"; ps = module.getSupportConnection().prepareStatement(sql); ps.execute(); However when I run this I get this exception: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.4 unexpected token: INTO required: FROM However I can run this from within MS Access just fine