ehuber
12-16-02, 10:43
| Hi all, I keep getting the exception below when I try to execute an update to a table using JDBC-ODBC. I have tried using "Statement.executeUpdate" but keep getting the same exception. --> java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. at sun.jdbc.odbc.JdbcOdbc.createSqlException(JdbcOdbc .java:6026) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java :6183) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java :2489) at sun.jdbc.odbc.JdbcOdbcStatement.execute (JdbcOdbcStatement.java:329) at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate (JdbcOdbcStatement.java:279) ------------------------------------------------------------------------- Has anybody got any ideas? Please!!!! Regards Lisa |