TMGR: Max Buffer Size Set Too Low (165041)

SYMPTOMS

IMPORTANT: This article contains information about editing the registry. Before you edit the registry, you should first make a backup copy of the registry files (System.dat and User.dat). Both are hidden files in the Windows folder.

When you install Team Manager you may cause a decrease in performance for programs using the Microsoft Jet Database engine, version 3.0.

You may also see the following behavior when replicating an Access 95 database using Jet 3.0 from Visual Basic 4.0.:

"Error 3183 Operation requires more space"

This behavior may also be reproduced with Access 95 replication which will produce the following error:

"Microsoft access can't make an additional replica at <database name and path>. Not enough space on temporary disk"

CAUSE

Team Manager will set the MaxBufferSize to 128 in the following key in the Windows registry:

   HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.0\Engines\Jet

when it is installed.

WORKAROUND

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved.

Use Registry Editor at your own risk.

For information about how to edit the registry, view the Changing Keys And Values online Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.

To edit the registry key to modify the buffer size, do the following:

Click the Start button, and click Run.
In the Open box type Regedit.

Go to the following registry key.

     HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.0\Engines\Jet.

Select MaxBufferSize, and from the Edit menu click Modify. Under Base, click decimal. In the Value data box enter 512 and click OK.

Another option would be to delete the DWORD entry for MaxBufferSize. To delete the DWORD, select MaxBufferSize and from the Edit menu click Delete. The deletion of the key will not affect the performance of other programs.

MORE INFORMATION

For more information about backing up the system registry, please see the following article in the Microsoft Knowledge Base:

135120 Configuration Backup Tool for Backing Up the Registry