Add Autonumber Field As Primary Key. A key symbol appears next to the field indicating that it is the tables primary key. To add AutoNumber field as Primary Key CustID to an existing table Customers make sure that the table does not have another field as AutoNumber.
So what can you do if you still want to use the AutoNumber datatype as a primary key. For more information on adding an AutoNumber field see the article Add an AutoNumber field as a primary key. In the Navigation Pane right-click the table to which you want to add the primary key and click Design View.
CREATE TABLE books id INT NOT NULL IDENTITY PRIMARY KEY title VARCHAR 100 NOT NULL primary_author VARCHAR 100.
Step 2 Right-click on the Column name. I have one existing table in that i need to add primary column with auto increment11. An AutoNumber field makes a good. Only method I know of to create an Autonumber field in a table is to use DAOTableDefs.