Solved

ACCESS 2007 report not enough memory to update display, any ideas?

Posted on 2009-07-10
6
679 Views
Last Modified: 2013-11-28
report and 2 sub reports
0
Comment
Question by:jadmin
6 Comments
 
LVL 3

Expert Comment

by:zemp1212
ID: 24825222
Hey check out this site of questions and answers for each scanerio for this problem.
 
let me know if any of this helps. It would be a mess to cut and paste.
 
http://www.utteraccess.com/forums/printthread.php?Cat=&Board=87&main=409571&type=thread
 
 
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 24825308
Some common reasons:

Corrupt report
Invalid or missing printer
No Default Printer specified, or Default printer is not a valid printer (i.e. a PDF printer, for example)
Corrupt database
Bad install of Access

First thing I'd suspect would be a corrupt report. If possible, try a Decompile. Click Start - Run and type this:

msaccess.exe "full path to your database" /decompile

If that completes, open Access and do a Compact & Repair (Office button - Manage).

If that doesn't work, you may need to delete the report and import it from a known good backup copy.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 25066170
jadmin,

<report not enough memory to update display, any ideas?>
Sure, ...as the error states...
    "not enough memory to update display"

How much *Available* memory do you have?
The would be the first thing I would check.

How big is this database?
Is it nearing the 2GB Limit?

Please remember that you did not post *any* details on your database, thus forcing us to guess at the dozens of things that might be causing this.

Does this happen on all databases?
On all Reports?
On all machines?
For all users?

Again you need to post more than just a one sentence question to get a useful response...

JeffCoachman
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:jadmin
ID: 25069239
<report not enough memory to update display, any ideas?>
Sure, ...as the error states...
    "not enough memory to update display"

How much *Available* memory do you have?
THEY are 1GB Memory
The would be the first thing I would check.

How big is this database?
Is it nearing the 2GB Limit?
  NO  it is 147 MB
Please remember that you did not post *any* details on your database, thus forcing us to guess at the dozens of things that might be causing this.

Does this happen on all databases?  NO
On all Reports? NO
On all machines? NO
For all users? NO

Again you need to post more than just a one sentence question to get a useful response...
Sorry have a lot going on with other things - isolated issue
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 25072022
OK,

Did you try LSMConsulting suggestion(s)?
0
 

Author Closing Comment

by:jadmin
ID: 31602159
ok problem is not as prevalent as it was before ... no longer a real issiue
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question