You can use the NewValues property to specify how AutoNumber fields increment when new records are added to a table.
Note The NewValues property applies only to AutoNumber fields.
Setting
The NewValues property uses the following settings.
Setting | Description |
---|---|
Increment | (Default) AutoNumber field values increment by 1 for new records. |
Random | AutoNumber field values are assigned a random Long Integer value for new records. |
You can set this property in the table's property sheet in table Design view by clicking the General tab in the Field Properties section.
Remarks
When you replicate a database, AutoNumber field settings are set to Random to ensure that new records entered in different replicas will have unique values.