set primary key from vba

[ChasW]

I am trying to find a common way to create a table that works in
access97 as well as it does in access2000.

Here is a snippet that works in access2000 but yields a syntax error
in access97:

strSQL = "CREATE TABLE tbl_myTABLE" & _
"([Field1] DOUBLE NOT NULL PRIMARY KEY, " & _
"[Field2] TEXT NOT NULL);"
db1.Execute strSQL

How do you set the primary key in access97?

[ChasW]

On Thu, 16 Nov 2006 00:22:11 -0500, ChasW <wrote:

>I am trying to find a common way to create a table that works in
access97 as well as it does in access2000.

Here is a snippet that works in access2000 but yields a syntax error
in access97:

strSQL = "CREATE TABLE tbl_myTABLE" & _
"([Field1] DOUBLE NOT NULL PRIMARY KEY, " & _
"[Field2] TEXT NOT NULL);"
db1.Execute strSQL

How do you set the primary key in access97?

I should rephrase that last question to:

Is it possible to create the table with a specific field being the
primary key without using a named table constraint?