Poor performance when you append data to a shared file-based database from a Windows XP-based client (825433)


The information in this article applies to:

  • Microsoft Windows XP 64-Bit Edition Version 2003
  • Microsoft Office Access 2003
  • Microsoft Windows XP 64-Bit Edition Version 2002
  • Microsoft Access 2002
  • Microsoft Windows XP Home Edition
  • Microsoft Windows XP Professional
  • Microsoft Access 2000


Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry

SYMPTOMS

When you write to a shared file-based database from a Microsoft Windows XP-based client computer, you may experience poor performance. For example, you may experience poor performance when you run a query that appends data to a Microsoft Access database that is stored on a file server.

CAUSE

This problem occurs because the Windows XP redirector prematurely flushes the cache and writes the whole database back to the server one time for each append transaction to the database.

RESOLUTION

Service pack information

To resolve this problem, obtain the latest service pack for Windows XP. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

322389 How to obtain the latest Windows XP service pack

Hotfix information

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next Windows XP service pack that contains this hotfix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the hotfix. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

Prerequisites

This hotfix has the following two prerequisites:
  • You must make sure that the Shell32.dll file has the following version or later.

    Windows XP 32-bit editions:
       Date         Time   Version        Size       File name    Service Pack level 
   ----------------------------------------------------------------------------------------------- 
   11-Jun-2003  18:43  6.0.2800.1233  8,240,640  Shell32.dll  with Windows XP Service Pack 1 (SP1)
   11-Jun-2003  18:53  6.0.2600.115   8,223,744  Shell32.dll  without Windows XP SP1
    Windows XP 64-bit editions:
       Date         Time   Version        Size        File name     Platform
   ---------------------------------------------------------------------
   11-Jun-2003  18:44  6.0.2800.1233  14,369,792  Shell32.dll   IA-64
   10-Jun-2003  15:39  6.0.2800.1233   8,240,640  Wshell32.dll  x86
    For instructions about how to verify the file version, see the "More Information" section.

    Note The version of the Shell32.dll file that is listed is the version that is installed when you apply the MS03-027 security update.

    For additional information about the MS03-027 security update, click the following article number to view the article in the Microsoft Knowledge Base:

    821557 MS03-027: An unchecked buffer in the Windows shell could permit your system to be compromised

  • You must also add and enable the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Lanmanworkstation\Parameters\DisableFlushOnCleanup registry subkey. For information about how to add and configure the registry subkey, see the "Add and enable the registry subkey" section.

Restart requirement

You must restart the computer after you apply this hotfix.

File information

The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.Windows XP 32-bit editions
   Date         Time   Version        Size     File name
   ------------------------------------------------------
   25-Mar-2004  22:34  5.1.2600.1367   92,160  Cscdll.dll       
   25-Mar-2004  22:24  5.1.2600.1367  420,736  Mrxsmb.sys
   25-Mar-2004  22:24  5.1.2600.1367  166,016  Rdbss.sys
Windows XP 64-bit editions
   Date         Time   Version        Size       File name    Platform
   -------------------------------------------------------------------
   25-Mar-2004  22:32  5.1.2600.1367    236,544  Cscdll.dll   IA-64
   25-Mar-2004  20:50  5.1.2600.1367  1,276,416  Mrxsmb.sys
   25-Mar-2004  20:50  5.1.2600.1367    495,616  Rdbss.sys
   25-Mar-2004  22:34  5.1.2600.1367     92,160  Wcscdll.dll  x86

Installation information

Verify the Shell32.dll file version
  1. Click Start, and then click Search.
  2. Click All files and folders.
  3. In the All or part of the file name box, type Shell32.dll.
  4. Click Search.
  5. In the right pane, right-click Shell32.dll, and then click Properties.
  6. Click the Version tab to view the file version.
Add and enable the registry subkeyWarning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To add and to enable the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Lanmanworkstation\Parameters\DisableFlushOnCleanup registry subkey:
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then click the following registry subkey:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Lanmanworkstation\Parameters

  3. On the Edit menu, point to New, and then click DWORD Value.
  4. Type DisableFlushOnCleanup, and then press ENTER.
  5. On the Edit menu, click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. Quit Registry Editor.
  8. Restart your computer.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft Windows XP Service Pack 2.

MORE INFORMATION

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

Modification Type:MinorLast Reviewed:10/28/2005
Keywords:kbHotfixServer kbQFE kbQFE kbWinXPsp2fix kbenv kbWinXPpreSP2fix kbfix kbbug KB825433 kbAudITPRO kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.