SQL issue creating a table

[KyleS]

I am trying to use SQL to create a table in my database with the Java DBMS I keep getting this error

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.

So I think it is not in my java code but the issue is actually in my SQL query, I have tried several variations but I still can't seem to get it to execute .

CREATE TABLE someTable(key VARCHAR PRIMARY KEY(20), someField VARCHAR(20), someOtherField VARCHAR(500), someReallyBigField MEMO)

Thanks for your help I really appreciate the time!

[June7]

Are you creating table in Access db or some other app db?

Did you try:

CREATE TABLE someTable(key VARCHAR(20) PRIMARY KEY, someField VARCHAR(20), someOtherField VARCHAR(500), someReallyBigField MEMO)

or

CREATE TABLE someTable(key VARCHAR(20) PRIMARY KEY, someField VARCHAR(20), someOtherField VARCHAR(500), someReallyBigField VARCHAR(max))

[KyleS]

Yes and I got this stack trace no joy

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unkn own Source)
at languageInterperater.databaseConnector.checkTable( databaseConnector.java:153)
at languageInterperater.databaseConnector.connect(dat abaseConnector.java:54)
at languageInterperater.langInterpMain.starting(langI nterpMain.java:66)
at languageInterperater.langInterpMain.main(langInter pMain.java:18)

[June7]

Well, I don't know what java expects but running the first SQL in Access works.

Maybe you need to post thread in a java forum.

[KyleS]

Tried that, they said it was the SQL :-p I will keep hunting around thanks for your time