auto incrementing field

[ray well]

hi

i need to create a autoincrementing primary key field in a access database
thru a sql command, (that kind of field is called a long integer in access,
and it autoincrements when a new record is added)

the following gets the field type created, but it doesn't auto increment.

CREATE TABLE tblCustomers ([Last Name] TEXT(5) NOT NULL, CustomerID UniqueID
INTEGER NOT NULL PRIMARY KEY UNIQUE)

what would be the word to make it auto increment?

thanks

ray

 

[Italo Silveira]

CREATE TABLE MyTable(ColName int identity (1,1) PRIMARY KEY)

Good luck,
Italo