Is there something wrong here?Code:CREATE TABLE MishaTable ( id AUTOINCREMENT CONSTRAINT pk_id PRIMARY KEY, col1 TEXT(20) NOT NULL, col2 MEMO(500) NOT NULL)
Cuz i get:
Code:java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement. at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110) at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338) at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)


Reply With Quote
Bookmarks