Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Course Of The Month
8 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Access 2000 - add Primary key
Posted on 2011-03-02
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,
[X]
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
5 Comments
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
It will automatically start at 1
You can set the primary key status using the "Key" toolbar at the top on your menu's
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month8 days, 5 hours left to enroll
617 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.