Bulk data insert into SharePoint list using access, Facing "Cannot update. Database or object is read-only" issue

Question

I have written a query to insert data into the SharePoint list which is linked to that database.

In some cases, I am able to insert data successfully but in other cases, after some time it showing "Cannot update. Database or object is read-only" and stops the execution, inserting few records in the SharePoint list.

Answer 1

Hi harsha,

Thank you for posting back and shared the information and cause with us.

We have read your description carefully. And it seems that you want to delete the old records in SharePoint list everyday and new data from Excel file. And you assume that the problem is related to network fluctuations, and it occurs randomly.

If my understanding is right, this issue may be related to that you inserted bulk data and you used Access to delete old records and update new records, due to the number of data is too large, during this period, the server may be overloaded and unresponsive, so multiple connections are required to succeed.

For the three questions you provided below, we want to provide some workarounds here to get rid of this behavior and make it easier:

1. Since you mentioned that you want to delete old records and deploy new records, if so, you can refer to this article: Create a list based on a spreadsheet to create a SharePoint list by importing an existing spreadsheet file. And in this way, you can delete the list with old records or save it, then you can create a new list with new records every day.
2. And according to our search, and we found your requirement may be achieved by Microsoft Flow. If you want to use Microsoft Flow to deploy it,

to make sure you get professional help, we’d suggest you post a new thread in Power Automate Community, that’s a specific channel to handle related questions. And we also searched a lot and we found the related thread, for your reference: Update SharePoint List from Excel file. 3. For the third workaround, and you can also use PNP code to delete all records in SharePoint list, and we have tested it on our side and it works fine, you may need to wait some time, and we will send the detailed steps in private message, you can see the detailed steps I provided in private message.

Hope the workarounds above can help you.

Best Regards,

Sukie

Answer 2

Hi Sukie,

Hope you're doing good, We have a requirement that deleting old records and deploying thousands of records to SharePoint list every day, For this process, we have chosen an access database, my location and SharePoint site location is in a far location, I think the problem is occurred because of network fluctuations.

I am creating this error intentionally by stoping my internet connectivity while inserting in the data to SharePoint list, please find the error below.

But in my case, this is happing without stoping the internet connectivity. Earlier I didn't see this error even if I upload thousands of records, but now I am triggering this error while uploading the SharePoint list(not every time).

I have 3 questions

1. could you please help me to get rid of this?
2. Is there any other easy alternative way to bulk upload data to the SharePoint list?

3. How to reset the ID, that should start with 1 while inserting?

Thanks in advance.

Regards,

Harsha.

Answer 3

Hi Sukie,

Your understanding was correct, Thanks a lot for your support and information, I will go through the process that you're mentioned above.

Regards,

Harsha.

Answer 4

Hi harsha,

Thank you for posting back.

And if you have any other questions in the further, you can post back and we will try our best to help you.

Best Regards,

Sukie