[Original] Initial Value Setting and resetting number of access automatic numbers

Today, I suddenly needed to set the initial value and step size for columns with automatic numbers in the Access database, but I found that no direct visual operation was performed. However, I think that since it can use SQL statements, it can be set with SQL statements. I tried it and it was OK.

Modify using SQL:

<! -- Modify the start value, step, and initialization ID of a table -->

The method is as follows:

Alter table tablename

Alter column ID counter (100, 5)

Where: tablename is the name of the table to be modified, ID is the auto-numbered column, 100 is the initial value, and 5 is the step size.

Similarly: If you want to reset the number, you only need to change 100 to 1.