When you run Microsoft Access for Windows 95 version 7.0, you may receive
the following error message:
Not enough free memory to update the display.
This error can occur at different times, for example:
- When you open a database with a startup form (as specified in the
Startup options on the Tools menu).
- When you use a main form with a subform control that has its
NavigationButtons property set to Yes.
- When you change Windows system settings (such as fonts, printer drivers,
colors, and so on) while a main form with a subform that contains
navigation buttons is open.
The resolution is dependent on the action you were performing at the time
you received the error message:
- If you receive the error message while opening a database with a startup
form, you can use an AutoExec macro to open the form instead of the
Startup options on the Tools menu. To do so, follow these steps:
- On the Tools menu, click Startup.
- In the Startup box, under Display Form, select the (none) option.
- Click OK to close the Startup box.
- In the Database window, click the Macros tab, and then click New.
- Create the following new macro:
Macro Name Action
Form Name: <form name>
- Close and save the AutoExec macro.
- Close and reopen your database. The AutoExec macro should open
your startup form automatically when you open the database.
- If you receive the error message while using a subform with the
NavigationButtons property set to Yes, you can turn off the
NavigationButtons property and add custom navigation buttons using
the Command Button Wizard. If your subform is displayed in Datasheet
view, you also need to change the DefaultView property to Continuous
Forms. To do so, follow these steps:
- Open your main form in Design view and delete the subform control.
Note that this deletes only the control, not the actual subform
object which is listed under Forms in the Database window.
- Switch to the Database window, click the Forms tab, and then click
- In the New Form box, select the AutoForm: Tabular Wizard, select the
table or query where the object's data comes from, and then click
- View the new form in Design view, and then set the following form
DefaultView: Continuous Forms
- Use the Command Button Wizard to add four new command buttons to the
form footer section. In the Command Button Wizard, under Actions,
select one of the following actions for each command button:
Go to First Record
Go to Last Record
Go to Next Record
Go to Previous Record
- Close and save the new form as NewSubformTest.
- Switch to your main form in Design view, and then drag the
NewSubformTest form from the Database window to the main form and
drop it in the former location of the original subform.
- Customize the subform control as appropriate; for example, set the
LinkChildFields and LinkMasterFields properties.
- Save your main form and switch the form to Form view. The subform
control should simulate a form Datasheet view.
- If you receive the error message after you change Windows system
settings while a mainform/subform that contains navigation buttons is
open, you should quit Microsoft Access and restart the application. The
best workaround for this situation is to quit Microsoft Access before
you make any system changes.
Microsoft has confirmed this to be a problem in Microsoft Access 7.0.
Article ID: 142931 - Last Review: October 26, 2013 - Revision: 2.0
|kbnosurvey kbarchive kbbug kbenv kberrmsg KB142931|