Solved

adobe distiller crash while printing ms access report (landscape, full page graphics)

Posted on 2008-10-01
5
497 Views
Last Modified: 2012-05-05
Distiller crashes on large, graphic intensive report generated by MS ACCESS.  full page graphic on landscape report, margins set to .5 all around.  Data is overlayed on graphic.  Graphic is grey-scaled .gif at about 500 kb, (linked and/or embedded--I've tried both).  Distiller is 8.1.2 with latest patches and works for everything else.

Machine is 2.8 Mhz with 3 Gb ram.  I've printed graphical data reports before to pdf, but this is largest.

I have tried various pdf settings without resolution, but can't be sure I'm doing this efficiently.

Report could easily surpass 1,000 pages.  I've tried smaller runs, but it still crashes.

Any hints for settings changes or resolution:
0
Comment
Question by:mkatzman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 10

Expert Comment

by:slamhound
ID: 22621103
MS Access is not very good at doing anything big so that's probably where your problem lies.

Will Distiller work fine on a sinle print page?
Can you try a 3rd party PDF maker to see if it makes a difference?
Can you give me any more details about the crashes?
0
 

Author Comment

by:mkatzman
ID: 22621224
Removed the graphic background (landscape 11 x 8.5) and still didn't work.  Wondering if whole report format is corrupted.

Have tried 3rd party pdf...  (universal...) but it didn't work much better... crashed on the 100th page, but adobe crashed on 2nd page.
About crashes:  When I print to Adobe pdf, I get the usual dialogue boxes... then it begins to compile the first page, hesitates (normal), starts the second page, and then I get the box "application failed...Send details to Microsoft..."

I nave tried different compresson schemes on the graphic.  As for doing big, I routinely compile 500 to 2000 page pdfs generated from Access, only not with this large a graphic.  Perhaps, tiling the graphic?
0
 
LVL 10

Expert Comment

by:slamhound
ID: 22621629
If you think there is corruption going on, you can create a fresh, new database and import the vital tables into it. Then import the report and see how it runs.

If this fails, create a brand new report and copy & paste items from your original report till you have the very bare bones (no graphic background, minimum calculations etc). If this works, keep adding components till you get your original report or it stops working again. This way you will be able to see what item is causing the crash.

The other think you can try is generating and outputing the report page by page. This way, you only ever have a single page youre dealing with at any one time so system resourses should not be a problem.
0
 
LVL 84
ID: 22622562
slamhound's right - the first order of business would be an import to a new db, if you're getting that error message.

I'd think tiliing the graphic would be more resource intensive.

One other thing to try would be to have your graphic at the same actual size as is being used in the report so Access doesn't have to stretch/resize/zoom it.
0
 

Accepted Solution

by:
mkatzman earned 0 total points
ID: 22624415
Going to try re-sizing the graphic and paring down excess code (there are several events triggered onFormat difference sections of the report.  This will probably take me most of the day, but this project is no behind schedule.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

726 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