Access 2000 - add Primary key

Posted on 2011-03-02
Last Modified: 2012-05-11
Dear Experts,

Could you please advise if there is a table in Access with a lot of columns but without primary key, is there possibility to add? If yes then through which menus?

My target would be to add a kind of autonumber, so the first record should have key 1, the 1000th record should have 1000.

Question by:csehz
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 11

Accepted Solution

Runrigger earned 500 total points
ID: 35016635
Open the table in design mode, simply add a field and call it ID, set the type to Auto number.

It will automatically start at 1

You can set the primary key status using the "Key" toolbar at the top on your menu's

Author Closing Comment

ID: 35016651
I have it, thanks very much your help

Author Comment

ID: 35016670
Runrigger can I ask a short yet?

For my live table which have more than 500000 records, I got error message

"File sharing lock count exceeded. Increase MaxLocksPerFile registry entry."

Do you have idea what is it?

LVL 11

Expert Comment

ID: 35016744
I haven't seen that before no, it's a registry setting.

Do you know how to open the registry? (Start-Run-regedit), do a search for MaxLocksPerFile

If not, can you ask another question to the experts.

Author Comment

ID: 35016765
Thanks your advise, I will try

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Omit After Update event 5 47
ACESS 2010 Query Criteria 23 57
Converting Access 2016 from 32-bit to 64-bit 8 63
Ms access query change into mysql database 3 25
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question