Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You cannot download data from a SharePoint list to Access 2010


View products that this article applies to.

Symptoms

You cannot receive data from SharePoint lists in Microsoft Access 2010 if the following conditions are true:
  • When Microsoft SharePoint Server 2010 runs slow.
  • You have a low bandwidth connection. 
  • You have a complex SharePoint list.

↑ Back to the top


Resolution

To resolve this issue, apply the following hotfix package:
2552989 Description of the Access 2010 hotfix package (Stslist-x-none.msp): June 28, 2011

Registry key information

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
After you install the hotfix package, follow these steps to enable the hotfix:
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then click one of the following registry subkeys: 
    • 32-bit Access on 32-bit Windows or 64-bit Access on 64-bit Windows
      • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines
    • 32-bit Access on 64-bit Windows
      • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines
  3. On the Edit menu, point to New, and then click DWORD (32-bit) value.
  4. Type DataFetchTimeout, and then press ENTER.
  5. In the Details pane, right-click DataFetchTimeout, and then click Modify.
  6. In the Value data box, type 00015f90, and then click OK.

    Note If the value does not resolve the issue, try a larger value. DataFetchTimeout is in milliseconds.
  7. Exit Registry Editor.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kbqfe, kbexpertiseinter, kbsurveynew, kbhotfixallversions, kb

↑ Back to the top

Article Info
Article ID : 2553007
Revision : 1
Created on : 1/7/2017
Published on : 2/8/2012
Exists online : False
Views : 257