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