Report Will Not Open

  • Thread starter Thread starter OldManEd
  • Start date Start date
O

OldManEd

I have only one of several reports that will not open either in view or
design view. All the others are ok.

The error message reads, "There isn't enough memory to perform this
operation. Close unneeded programs and try again..." My Vista computer has 3
GB of ram!!

This happens both using Access 2003 (512 MB Ram) and Access 2007.

How do I get this program to open?

ed
 
Sounds like the report has gone bad. Can't promise, but see if this rescues
it:

1. Make a back up of your MDB, so you get mulitiple chances at fixing it.

2. Open the Immediate Window (Ctrl+G), and enter:
SaveAsText acReport, "Report1", "C:\MyFolder\Report1.txt"
substituting your report name for Report1, and your path for MyFolder.

3. If that works (no error, and you see the text file in the folder), delete
the report from the database. Compact/Repair. Then open the Immediate
Window, and ask Access to recreate the report from the text file:
LoadFromText acReport, "Report1", "C:\MyFolder\Report1.txt"

If the attempt to use the (undocumented) SaveAsText fails, you will need to
delete the report, compact, and create it again from scratch.
 
OldManEd said:
I have only one of several reports that will not open either in view or
design view. All the others are ok.

The error message reads, "There isn't enough memory to perform this
operation. Close unneeded programs and try again..." My Vista computer has 3
GB of ram!!

This happens both using Access 2003 (512 MB Ram) and Access 2007.

How do I get this program to open?

ed
Click to expand...

On this site, another Vista user seems to have had a similar problem and
found it helped to Print without Previewing
http://www.utteraccess.com/forums/showthreaded.php?Cat=&Number=1582160&page=
&view=&sb=5&o=&vc=1

Sounds like 'Vista Strikes Again'
Evi
 
Back
Top