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,
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,
Who is Participating?
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,
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,
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.
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.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
It will automatically start at 1
You can set the primary key status using the "Key" toolbar at the top on your menu's