Solved

Access 2000 - add Primary key

Posted on 2011-03-02
5
285 Views
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.

thanks,
0
Comment
Question by:csehz
  • 3
  • 2
5 Comments
 
LVL 11

Accepted Solution

by:
Runrigger earned 500 total points
Comment Utility
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
0
 
LVL 1

Author Closing Comment

by:csehz
Comment Utility
I have it, thanks very much your help
0
 
LVL 1

Author Comment

by:csehz
Comment Utility
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?

thanks,
0
 
LVL 11

Expert Comment

by:Runrigger
Comment Utility
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.
0
 
LVL 1

Author Comment

by:csehz
Comment Utility
Thanks your advise, I will try
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

772 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now