I have a database with many records that I realize now I should have added an Auto Number field to the table and made it the Primary Key. Can I now add an Auto Number field to the table and make it the Primary Key? If so, how?
Novice
Windows 2K 
Access 2000
I have a database with many records that I realize now I should have added an Auto Number field to the table and made it the Primary Key. Can I now add an Auto Number field to the table and make it the Primary Key? If so, how?
VIP
Windows 7 64bit Access 2010 32bit
You can. Open table in design view and add autonumber field. Might have to delete some relationships before allowed to change the PK designation.
However, if there are already relating tables that will need this new value as foreign key, will also need new field in related table(s) and update with the new value.
An autonumber field does not have to be PK although that is often the best approach.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Is there an easy way to reorder an auto number field?
Posting Permissions
Reply With Quote