I've now changed that so both make & flavour is
of VARCHAR type. Once this had been done I compiled
and ran the codeand got the following error:
<br><br>Connection Established<br>java.sql.SQLException:
[Microsoft][ODBC Microsoft Access Driver] table  'COFFEES' already
exists.<br> at
sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)<br> at
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)<br> at
sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:2494)<br> at
sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:314)<br> at
sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:264)<br> at
connectiontest2.main(connectiontest2.java:49)<br><br>It says the table COFFEES
already exists so I
changed the name of the 2nd table to test but got the
exact same error message.