"Contralto" <Al**********@g mail.comwrote in message
news:11******** **************@ e9g2000prf.goog legroups.com...
Hi, I can convert my report to Adobe PDF, but the photos are very
poor. They were taken as RAW images and I've tried saving them at
different resolutions as JPEGs, but it doesn't seem to make much
difference in the PDF output. I have about 500 images in the 200ish
page report (unless I split it into several smaller ones).
Each photo should be about 6-8cm on the longest side. Any
recommendations on what res to use would be most appreciated. The
photos are all in a different drive from the database and the report
picks them up and compiles the finished product.
I have had good luck with images in reports, using the techniques described
in the articles referenced below. I do not recall, in recent years, saving
reports with images via Adobe Acrobat, but I would guess that is where your
problem lies... Acrobat, or other PDF-saving software, and its
use/implementation of graphics.
The sample imaging databases at
http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.
If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans'
http://www.lebans.com/printfailures.htm.
PrintFailure.zi p is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.