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

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

Good luck,
Italo


"ray well" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
>