What is the maximum number of auto-numbering in Access?

1, the data type of automatic numbering is long integer type. The following is a description:

A long (integer) variable is stored as a 32-bit (4-byte) signed numeric form, ranging from 2,147,483,648 to 2,147,483,647. The type declaration word identifier and number (&) of Long.

2, if the automatic numbering starting from 1, once the arrival of 2147483647 will automatically jump to 2147483648, and then continue to shrink, until 0.

3. If you reach 1 again, if you define an AutoNumber field in the Design table, the Index property is "have (No Duplicates)" and the system will prompt an error. If not set, the AutoNumber continues to increase from 1 onwards

4, Replication ID, Replication ID is also called Global Unique identifier (GUID: In an Access database, a 16-byte field used to establish a unique identifier for a synchronous replication. GUIDs are used to identify replicas, replica sets, tables, records, and other objects. In an Access database, the GUID refers to the replication ID. ）)。 N/A 16 bytes
Content similar to {8aed7962-cfe3-481a-a513-e5346b75029d}
If you need to convert a data type, you can generally convert to text.