Solved

Access 2000 - add Primary key

Posted on 2011-03-02
5
324 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
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
0
 
LVL 1

Author Closing Comment

by:csehz
ID: 35016651
I have it, thanks very much your help
0
 
LVL 1

Author Comment

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

thanks,
0
 
LVL 11

Expert Comment

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

Author Comment

by:csehz
ID: 35016765
Thanks your advise, I will try
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

713 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