I am facing an issue with adding one functionality to the Access Database form.
I have created a form with one of the table say table1, form has to display all the data of the table.
The user should be able to amend any details except for the primary key of the table. Also the user should be able to add new rocords.
Primary key may not be necessarily auto generated, it can be text.
How can I incorporate this functionality? Any help in this direction will be greately appriciated