Article ID: 825433 - Last Review: November 15, 2007 - Revision: 3.6

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

Hotfix download is availableHotfix Download Available
View and request hotfix downloads
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  (http://support.microsoft.com/kb/256986/ ) Description of the Microsoft Windows registry

On This Page

Expand all | Collapse all

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.
Back to the top

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.
Back to the top

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  (http://support.microsoft.com/kb/322389/ ) How to obtain the latest Windows XP service pack
Back to the top

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 (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  (http://support.microsoft.com/kb/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.
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. This problem was first corrected in Microsoft Windows XP Service Pack 2.
Back to the top

MORE INFORMATION

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
824684  (http://support.microsoft.com/kb/824684/ ) Description of the standard terminology that is used to describe Microsoft software updates
Back to the top
APPLIES TO
  • Microsoft Windows XP 64-Bit Edition Version 2003
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
  • Microsoft Windows XP Home Edition
  • Microsoft Windows XP Professional
  • Microsoft Access 2000 Standard Edition
Back to the top
Keywords: 
kbautohotfix kbhotfixserver kbqfe kbqfe kbwinxpsp2fix kbenv kbwinxppresp2fix kbfix kbbug KB825433
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations

 

Related Support Centers