Solved

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

Posted on 2008-10-01
5
490 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
  • 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

The ability to edit PDF documents can be useful, however it may not be a straight forward process. Many non-technical people don't realise that a PDF document is basically an image rather than a text file, even if it contains nothing but text. If…
This article is in response to a question here (http://www.experts-exchange.com/Other/URLs/Q_28283850.html) at Experts Exchange. The Original Poster has a scanned signature and wants to make the background transparent so that the signature may be pl…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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…

747 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now