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
Cannot update. Database or object is read-only.
The Microsoft Office Access database engine could not find the object '<linked table name>'. Make sure the object exists and that you spell its name and the path name correctly.
Linked table '<linked table name>' is unavailable. Microsoft Access cannot contact the server. Check your network connection or contact the server administrator.
You do not have the necessary permissions to use the '<linked table name>' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.
Or, you may experience one of the following issues:
- 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. Specifically, if Access doesn’t receive the data for the given batch after 30 seconds, it aborts the request and may resend the batch as a new request. If Access encounters failures when sending these batches, the program may give up and return an error message.
Some conditions that may cause this issue are:
- There's a problem with the health of the Microsoft SharePoint Server, for example, it runs slowly.
- You have a low-bandwidth connection.
- You have a large or complex SharePoint list or document library.
- There's a long distance between you and the server.
- There are more than 255 columns in the SharePoint list or document library.
- You are throttled when you use SharePoint Online. For more information about throttling in SharePoint Online, see Avoid getting throttled or blocked in SharePoint Online.
To fix the issue, use one of the following methods:
- Method 1: Reduce the response time by avoiding the conditions that may cause the issues.
- Method 2: Reduce the amount of data requested from the server by using a view in SharePoint and then linking Access to that view.
For detailed information on how to create a linked table which uses the SharePoint view, see ImportSharePointList Macro Action.
- Method 3: Increase the time-out in Access by adding the DataFetchTimeout registry entry
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 - How to back up and restore the registry in Windows