Practical Scenario:
This regards an Access 2010 accdb with a SQL Server back end: This front end is using a linked view to enter or update data (using INSTEAD OF trigger). The problem is that every so often it gives the "Cannot update. Database or object is read-only" error when trying to enter or update data through this view. The only thing that fixes this issue is deleting the linked view, re-linking it and setting the primary key again. However, this fix doesn't last; the problem usually shows up again the next day and has to be fixed again.
