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, relinking 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.
Is there a way to do this automatically? That is when the user opens the front end some code runs that relinks this view and sets its primary key? Any other ideas on how to solve this issue?
Thanks!
Accdb linked view error: "Cannot update. Database or object is read-only"
Question Info
Last updated October 5, 2021 Views 18 Applies to: