AutoNumber is a type of data used in Microsoft Access tables to generate an automatically incremented numeric counter.
[2] If an AutoNumber is a long integer, the NewValues property determines whether it is of the start+increment or random form.
Deletion of rows from a table, for example, does not cause AutoNumber fields to be re-numbered, but instead leaves "holes" in the numbering.
[2] Such replication IDs, being GUIDs, will be unique across replicas, with a low probability of collision.
[4] The following Data Definition Language (DDL) query creates an AutoNumber field with a start value and an increment: This query resets the counter: An alternative method of resetting the counter is to drop column re-add it (this has the side effect of renumbering existing rows in the table):