I have an Access 2010 front end linked to SQL Server 2008. There is an error when pasting null records into a form. The form uses a linked view and the Required settings when I look at design view on the Access "table" says required Yes. So linked to the same table that I have the view for, and it does show the Required settings the way it should be, but not in the linked view. I want to use a linked view and not a linked table. Is there a way I can get the linked view to show the required setting as Required No?
The primary key of the table in SQL Server is ID and I select ID when I created the linked object in Access 2010.
Here is a screenshot of the linked view in design mode in Access.
Here is a screenshot of the linked table in design mode in Access.
Thanks for your help.