Hi Folks,
I have this classic problem, "Recordset Not Updateable" for which one can find many resources on the net and also in these forums as well.

Too bad, none of the findings solved my problem.

Access 2010 Data Access Project connecting to MS SQL Server 2008.

User A has 2010 as well, and is able to update records (task is to change status)
User B uses Windows 8 with Access 2010, tries to update records with the same form, but he can't, access is telling the annoying recordset not updatable.

The recordset is based on a SQL server view, that selects a column that has a unique index on it, and the only column that changes is from this table. Apart from that, 4 additional tables are joined with LEFT OUTER JOIN.



I checked the form and its recordset is set to Updatable Snapshot. ( the only other option is Snapshot)....

Would appreciate any help.