[thelist] Create MS Acces table with AutoNumber field

[Anderson, Mark S.]

Hi Folks,

I need to create a table in Microsoft Access using the DDL.  The table
needs an AutoNumber field, but I can't figure it out.

This is what I'd like to do, but doesn't work:

create table MYTABLE
(
ID AUTONUMER PRIMARY KEY,
DATA TEXT(255)
)

- Mark