hi friends i am a junior developer i have assigned a project by my team leader. in this project use ms access database and i need to set two column primary keys in a table . please help me any one .
thanks.
How do you set two primary keys in access?
116616-Jul-2020
Updated on 16-Jul-2020
Anonymous User
27-Jul-2020Add a two field as a primary key
1. Open MS Access and select the Blank Desktop database.
See below image ->
2. After clicking the Blank Desktop database a popup will be open.
See below image ->
3. In the Navigation Pane, right-click the table and click Design View.
see below image->
4. Now select two-column to which you want to add the primary key and click the primary key button.
See below image->
I hope it will help to you.