|
|
How to view or change the Jet (Access 2000/2002/2003) or ACE (Access 2007/2010) MaxBufferSize
Author: Steve Childs Reference Number: AA-01449 Created: 2011-03-16 16:02 Last Updated: 2011-08-11 06:50 |
0 Rating/ Voters
|
![](http://kb.onesourcesoftware.com/support/kb/admin/images/local/FirstTheme/ico-rating-g.gif) ![](http://kb.onesourcesoftware.com/support/kb/admin/images/local/FirstTheme/ico-rating-g.gif) ![](http://kb.onesourcesoftware.com/support/kb/admin/images/local/FirstTheme/ico-rating-g.gif) ![](http://kb.onesourcesoftware.com/support/kb/admin/images/local/FirstTheme/ico-rating-g.gif) |
(If Access intermittently hangs for a x seconds or minutes you may need to increase the MaxBufferSize to allocate more memory to Access. This article explains how to do this).
- Click Start, and then click Run.
- Type regedit, and then click OK.
- Use the appropriate method:
- In the right pane of Registry Editor, double click MaxBufferSize.
- On the Edit DWORD Value dialog box, click Decimal.
- Modify the value of the Value data box as required, and then click OK. (For ideas of what number to enter, see notes below).
Note: Try changing the value to 50000. If the problem still persists, try doubling it. (Additional note: Supposedly you can enter in a value up to 1/4 of the total RAM. To calculate figure 1024 x each MB. Example: If have 4 gigs. 1/4 is about 1 gig. 1024 x 1000 (1 gig = about 1000 MB) = 1024000)
|
|
|