Solved

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

Posted on 2009-07-10
6
681 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

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…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

839 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