- 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 '' 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.
- Access quits expectedly (or crashes) when trying to open a linked table.
- Access appears to be in a deadlock state when trying to open a linked table.
- When there is 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/document library.
- There is a large distance between you and the server.
- There are more than 255 columns in the SharePoint list/document library.
To resolve this issue in Access 2010, apply hotfix (KB 2552989) which will allow the timeout behavior to be a configurable value. KB 2553007 provides the steps on creating the necessary registry key to specify the new timeout value.
KB 2552989 Description of the Access 2010 hotfix package (Stslist-x-none.msp): June 28, 2011
KB 2553007 You cannot download data from a SharePoint list to Access 2010
If the hotfix and changes to the registry do not resolve this issue in Access 2010, try the steps listed in the Access 2007 section below.
To resolve this issue in Access 2007, try the following:
- Sometimes hitting F5 (refresh all) will cause Access to complete the process.
- Even though the view is showing less than 255 columns, the list or document library has over 255 columns and one of the columns Access is trying to show could be saved in a column past the 255 limit. Unfortunately, there is no way to control this aside from ensuring the SharePoint document library has no more than 255 columns.
To see all columns in the SharePoint list/document library you will need to use something like the SharePoint Manager. You can download SharePoint Manager 2007 version and 2010 version from: SharePoint Manager 2007 http://spm.codeplex.com/releases/view/22762
- Consider linking to a view of the SharePoint list that returns fewer rows of data. In order to create the linked table to the SharePoint view, you must use the TransferSharePointList macro action.
Access Team Blog - Access 2010: Performance improvements against SharePoint lists
Access Team Blog - Access 2007 link table to SharePoint list performance
Article ID: 2702762 - Last Review: 14 Sep 2012 - Revision: 1