Microsoft KB Archive/148445

= ACC: "Out of Memory" Opening Access 2.0 Database in Access 95 or Access 97 =

Article ID: 148445

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q148445



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.



SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.

When you open a Microsoft Access version 2.0 database for the first time in Microsoft Access version 7.0 or 97 without converting the database to the later version, you may receive the following error messages:

Out of Memory

I/O Device Error



CAUSE
The Microsoft Jet database engine version 2.x ISAM is out of buffer space. This can occur when the Microsoft Access version 2.0 database contains many form modules and/or report modules.



RESOLUTION
Increase the number of buffers available to the Microsoft Jet database engine version 2.x ISAM by setting the MaxBufferSize parameter in the Windows Registry.

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows 95. 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 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 set the MaxBufferSize parameter in Microsoft Access 7.0, follow these steps:

  Start the Registry Editor and navigate to the following key:

     \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.0\Engines\Jet 2.x                         Using the right mouse button (right-click), click the "Jet 2.x" key, point to New, and then click Key. Type the following name for the new key:

ISAM  Right-click the "ISAM" key, point to New, and then click DWORD. Type the following name for the new DWORD:

MaxBufferSize </li> Right-click the "MaxBufferSize" DWORD, and then click Modify.</li> In the Edit DWORD Value box, click the Decimal base option.</li> In the Value Data box, enter 1024, and then click OK.

NOTE: If your Microsoft Access version 2.0 database is very large, you may want to use a higher value, such as 2048. The maximum value is 4096 using the Decimal base option (or 1000 Hexadecimal).</li> Quit the Registry Editor.</li> Start Microsoft Access 7.0 and open the Microsoft Access 2.0 database (without converting it). The database should open without error.</li></ol>

To set the MaxBufferSize parameter in Microsoft Access 97, follow these steps:

<ol>  Start the Registry Editor and navigate to the following key:

<pre class="fixed_text">     \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Jet 2.x                        </li> Using the right mouse button click the "MaxBufferSize" DWORD, and then click Modify.</li> In the Edit DWORD Value box, click the Decimal base option.</li> In the Value Data box, enter 1024, and then click OK.

NOTE: If your Microsoft Access version 2.0 database is very large, you may want to use a higher value, such as 2048. The maximum value is 4096 using the Decimal base option (or 1000 Hexadecimal).</li> Quit the Registry Editor.</li> Start Microsoft Access 97 and open the Microsoft Access 2.0 database (without converting it). The database should open without error.</li></ol>

Keywords: kbprb KB148445

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.