Fix [Microsoft][ODBC Microsoft Access Driver] Cannot Update. Database Or Object Is Read-Only Error

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.

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! 

Are you also a victim of this Database or object is read-only" error? If yes then just go through this post and know the best fixes to resolve this specific error code.

About access “Database or object is read-only” error:

You will get the following error code when you work in a Microsoft Access table which is linked to a Microsoft SharePoint lists that contains hidden metadata column.  At that time the following error appears to your screen, i.e  Cannot update. Database or object is read-only.

Cause

• The error is mainly because of the issue generated when Microsoft Access table is linked to a SharePoint list that has hidden metadata.

• Well the database is read only for one of these reasons:

• May you have used the OpenDatabase method and opened the database for read-only access.

• In Microsoft visual basic, you are using data control and you have set the ReadOnly property to True.

• Chances are also that the database file is defined as read-only in the operating system or by your network.

• Database is stored on any read-only media.

• In the network environment you don’t need to write privileges for the database file.

• While working the secured database, either the database itself or its objects may be set to read-only. You don’t have the permission to access this data with your user name and password.

Workaround Access “Database or object is read-only” error

Method 1

Link the entire lookup column in the underlying list to tables. For this, just follow down theses steps:

1. Like to SharePoint list itself. This assures that all lookup tables for the underlying list are present within Access.

2. Now delete the linked table for the SharePoint list in Access.

3. After this link the SharePoint view by using theImportSharePointList macro action.

Conclusion:

Following all these above mentioned steps, will help Access to make a linked table for the SharePoint view and linked table for the entire Lookup columns in the underlying list instead for only the lookup columns which are included in the view.