Microsoft KB Archive Search

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.

  1. Home
  2. Access 2010 may crash when you use sorts or calculated totals, or when you switch views by using pivot tables

Access 2010 may crash when you use sorts or calculated totals, or when you switch views by using pivot tables

View products that this article applies to.

Symptoms

Consider the following scenario:
  • On a computer on which you are running Microsoft Access 2010, you install Microsoft SQL Server 2008 R2 November Community Technology Preview Feature Pack. Or, you install the PowerPivot add-in for Excel.
  • In Access 2010, you use sorts or calculated totals, or you switch views by using pivot tables.
In this scenario, Access 2010 may crash.

↑ Back to the top

Resolution

To resolve this issue, follow these steps:
  1. Uninstall SQL Server 2008 R2 November Community Technology Preview Feature Pack or the PowerPivot add-in for Excel.
  2. Locate the following files:
    • Msolap100.dll
    • Msmdlocal.dll
    • Msmgdsrv.dll�
    • Msolui100.dll
  3. Rename these files as follows, respectively:
    • Msolap100.dll.old
    • Msmdlocal.dll.old
    • Msmgdsrv.dll.old
    • Msolui100.dll.old
  4. Use the Microsoft Office 2010 installation wizard to repair Office 2010. After you do this, the DLL files are reinstalled.

↑ Back to the top

Keywords: KB2288054, kbprb

↑ Back to the top

Article Info
Article ID : 2288054
Revision : 3
Created on : 8/25/2011
Published on : 8/25/2011
Exists online : False
Views : 438