Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2008-10-01
5
Medium Priority
?
514 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 85
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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

604 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