Identity on MS Access

[octane]

My sql script look like this
create table ENVIO
(
ID Integer not null,
CLAVE_REM Integer not null,
CLAVE_DES Integer not null,
FECHA DateTime not null ,
GUIA Integer null ,
AUTORIZO Text(30) not null,
DEPTO Text(30) not null ,
PAGA Text(30) not null ,
DESCRIPCION Memo null
);

I need the field ID be autonumber type, I know that SQL has IDENTITY but in MS Access the only thing that I get is an error.

create table ENVIO
(
ID Integer IDENTITY not null,
CLAVE_REM Integer not null,
CLAVE_DES Integer not null,
FECHA DateTime not null ,
GUIA Integer null ,
AUTORIZO Text(30) not null,
DEPTO Text(30) not null ,
PAGA Text(30) not null ,
DESCRIPCION Memo null
);

Does any one know how to create a Auntonumber field in MS Access with a SQL script???

 

[tlbroadbent]

Use the keyword Counter to create an Autonumber column.

create table ENVIO
(
ID Counter not null,
CLAVE_REM Integer not null,
CLAVE_DES Integer not null,
FECHA DateTime not null,
GUIA Integer null,
AUTORIZO Text(30) not null,
DEPTO Text(30) not null,
PAGA Text(30) not null,
DESCRIPCION Memo null
);
Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.