Hardware

Ask something
Question Locked

Access 2007 - There isn't enough free memory

0 helpful
10 replies

by chaver

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi
Looking around the web there appears to have been a problem with MS Access from 97 to 2003. This problem seems to still be present with 2007!
I have a report that I am outputting (Docmd.OutputTo) to a pdf file - all works fine until the Adobe Reader is displaying the report - then an Access message comes up:

There isn't enough free memory to update the display. Close unneeded programs and try again.

This error has no error number and is not trappable! I am now running the code in debug mode - so there is nothing on the display to update. The report is produced as a pdf file and is displayed on the screen in Adobe Reader.

Has anyone any suggestions as to how to get rid of this message. Incidentally I tried running it as a Macro - same problem.

Thanks
chaver

10 replies

by patb071

What are the specs on your machine? OS, CPU speed and Ram?

by chaver

That note refers to Access 2000 and does not appear to be relevant on 2007

by chaver

Windows Vista Ultimate V6.0 SP1
2Gb Memory
Office Suite updated Daily

by patb071

Sorry it said 2007 in the search page. Have you tried running the diagnostics? Office Button- Access Options- Resources- Run Microsoft Office dianostics. Also There is a feature in Office button-manage-compact and repair database. I would backup your aceess databases first. This worked for a different issue i had.

by chaver

Yep
Tried both - Diagnosis found no problems - Repair ran OK.

But still getting the message.

Seems maybe to have something to do with pictures - the report has pictures in it - all .jpgs and all less that 80k.

by chaver

I have created a new database - 1 Table - 1 Report.

Filled the table with rubbish values. Imported my OutputTo routine and ran it to a dummy file.

All ran OK - no error message - PDF file OK.

by patb071

OK so you have narrowed down to where the problem is. Converting the PICS to PDF. Do you see an acrobat tab? In there select preferences and go to advanced settings. I have never used pics in a report but i would start playing around with the settings to see if you can get it to work.

Good Luck

by f5tornado

i know the post is old - however, the problem is still relevant/prevalent. Just did a clean install of Windows 7 Ultimate 64-bit 8GB RAM/Office 2007 with all sp's and updates - the error message popped up on one of the databases when previewing a report. the problem disappeared when the networked hp laserjet was turned on - AND - the report's Pop Up and Modal properties were set to No - AND - the Default View was set to Report Preview. not sure which of these "fixes" was the answer, but altogether they worked (leaning towards popup and modal as the culprits).

This discussion is closed to new replies.