• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 556
  • Last Modified:

add identity column to Access Database

I have an Access 2007 database that I am trying to work with, and the previous creator made some design questions that don't make sense. there are about 15 different tables, and none of them have identity columns. The primary key was designated using the nvarchar data type.

I understand how to add a new column, but need help with going through each item in the table and assigning an ID.

1 Solution
Jeffrey CoachmanCommented:
In Access an Identity Columns know as a "AutoNumber" field.

Open the table in design view
Insert a new column (Field)
Name the Field
Select "Autonumber" as the data type

...Is this what you wanted?
brendanlefavreAuthor Commented:
setting autonumber was the piece that I was missing.

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now