SQL string trouble

[Steph]

I'm trying to create a table in Access97 using an SQL string in Java (jdk1.1.8).
All's fine until I try to define a PRIMARY KEY, after that it compiles beautifully
but won't run. Unable to ascertain whether the issue's with Java's jdbc/odbc
bridge, SQL or Access, but am pretty positive it's not the SQL unless constraint
statements run differently in Java. Err msg is "SQLException: [Microsoft][ODBC
Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.

Does anyone know of a workaround, or do I need to find an alternative bridge?

Thanx,
Steph

[Steph (again)]

"Steph" <steph.fox@btinternet.com> wrote:
>
>I'm trying to create a table in Access97 using an SQL string in Java (jdk1.1.8).
> All's fine until I try to define a PRIMARY KEY, after that it compiles
beautifully
>but won't run. Unable to ascertain whether the issue's with Java's jdbc/odbc
>bridge, SQL or Access, but am pretty positive it's not the SQL unless constraint
>statements run differently in Java. Err msg is "SQLException: [Microsoft][ODBC
>Microsoft Access 97 Driver] Syntax error in CREATE TABLE statement.
>
>Does anyone know of a workaround, or do I need to find an alternative bridge?
>
>Thanx,
>Steph


- no wucking furries, I've cracked it!
CONSTRAINT INDEX1 PRIMARY KEY (field)- it's a Microsoft thang, ennit?

Cheers anyway,
Steph