AutoNumber data type

[Guest]

The following code works with all data types except AutoNumber. I get a
"Syntax error in field definition" error message. Can anyone help me make
AutoNumber work?

DoCmd.RunSQL "CREATE TABLE tblTest(XYZ Datetime);"

 

[Douglas J. Steele]

I believe you use Identity rather than Autonumber.

 

[Guest]

I get the same error message with:

DoCmd.RunSQL "CREATE TABLE tblTest(XYZ Identity);"
--
Thank you,
Del

I believe you use Identity rather than Autonumber.

 

[Douglas J. Steele]

Sorry, that's what I get for not looking it up.

DoCmd.RunSQL "CREATE TABLE tblTest(XYZ Counter)"


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I get the same error message with:

DoCmd.RunSQL "CREATE TABLE tblTest(XYZ Identity);"

 

[Guest]

Thanks, that works.
--
Thank you,
Del

Sorry, that's what I get for not looking it up.

DoCmd.RunSQL "CREATE TABLE tblTest(XYZ Counter)"

 

[RoyVidar]

Sorry, that's what I get for not looking it up.

DoCmd.RunSQL "CREATE TABLE tblTest(XYZ Counter)"

The identity syntax works, but on an ADO connection, for instance

CurrentProject.Connection.Execute _
"CREATE TABLE tblTest(XYZ Int Identity);"