I have noticed that it is necessary to set the primary key in table. I have linked the sql server tables in Access. If primary key is not set then it doesn't allow to add, update and delete any of the records in the Access.

Is there any way to solve this problem.