Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

Access 2000 - add Primary key

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
csehz
Asked:
csehz
  • 3
  • 2
1 Solution
 
RunriggerCommented:
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
 
csehzAuthor Commented:
I have it, thanks very much your help
0
 
csehzAuthor Commented:
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
 
RunriggerCommented:
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
 
csehzAuthor Commented:
Thanks your advise, I will try
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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