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

Article translations Article translations
Article ID: 825433 - View products that this article applies to.


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
Expand all | Collapse all

On This Page

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 available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing this specific problem. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support
Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

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 subkey
Warning 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

Properties

Article ID: 825433 - Last Review: November 15, 2007 - Revision: 3.6
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 Standard Edition
  • Microsoft Windows XP Home Edition
  • Microsoft Windows XP Professional
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbautohotfix kbhotfixserver kbqfe kbqfe kbwinxpsp2fix kbenv kbwinxppresp2fix kbfix kbbug KB825433

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com