Contents
Is there an error executing the bulk query?
This query ran without issue for a couple weeks but now the end users receive the below error message fairly frequently. “There were errors executing the bulk query or sending the data to the server. Reconnect the tables to resolve the conflicts or discard the pending changes”.
Synchronizing a SharePoint list with Access 2010 makes it much easier to do bulk changes to your SharePoint list data. To bulk add, update, or delete data from a SharePoint list, run an append, update, or delete query in Access 2010, and then open or refresh the SharePoint list.
How to update the SharePoint access linked table?
As the SharePoint list continues to be updated, you can also manually refresh the Access linked table with the latest list changes. As the Access linked table continues to be updated, you can also manually refresh the SharePoint list data with the latest Access changes.
What happens when you request data from SharePoint lists?
When you request data from Microsoft SharePoint lists in Microsoft Access, you may receive one of the following error messages: There were errors executing the bulk query or sending data to the server. Reconnect the tables to resolve the conflicts or discard the pending changes. All SharePoint tables are disconnected.
Access exits unexpectedly or crashes when you try to open a linked table. Access appears deadlocked when you try to open a linked table. When Access requests list items from a SharePoint list, Access waits a finite period of time for that data to be returned.
Reconnect the tables to resolve the conflicts or discard the pending changes. All SharePoint tables are disconnected. Cannot update. Database or object is read-only. The Microsoft Office Access database engine could not find the object ‘ ‘. Make sure the object exists and that you spell its name and the path name correctly.