How to implement an auto increment column in MS Access?
Use the COUNTER data type when you want to define an auto increment/auto number/identity column in MS Access. The COUNTER data type provides a monotonically increasing sequence of long integers for a column in a MS Access database.See also: About Primary Keys and auto increment columns