Insert the primary key with automatic addition to the access table

We have a giant table in the Access database with more than 500 thousand records and without a PC. Can I insert an automatically growing primary key column into an existing Access table?

+7
source share
1 answer

Yes, this can be done quite simply by editing the table and adding a field such as auto-increment. The only rule: you can have only one auto-increment per table.

autoincrement

+8
source

All Articles