A field data type that automatically stores a unique number for each record as it is added to a table. An AutoNumber field always uses the Long data type. Numbers generated by an AutoNumber field cannot be modified unless special permission has been granted to the table through either the Grant or Revoke statements in SQL DDL syntax. The AutoNumber field is also known as a Counter or Identity data type. When using SQL DDL, this data type now supports varying seed and increment values. This differs from previous versions where the seed value was 1 and the increment value was 1.
See Also