I have a SQL Server 2005 database which has some views (each view is one table only). I want the users to be able to link to the views in Access 2003 and update the data. I get the views to link fine, but they are all read only.
The users have all permissions on the views but none against the tables. Is this the problem?