Problem printing large report with images

[pvcc]

I’ve created a 2-page report going to 3000 clients (7000 pages ). Page 1 of the report contains typical text and numeric data and page 2 has an individualized map (based on 3000 .jpg external files-each file about .8MB). The problem is that after approximately 200 pages the map image no longer appears on page 2 of each report.

As a work-around a form was created that allows the user to print based on a start ID and end ID. This approach works but only if 75 map reports are created at a time. Client is not enthusiastic about this approach.

Is there another approach to print all records at once?

Is this a memory problem? Limitation of Access?

Any suggestions are appreciated. Thanks

 

[HitechUser]

pvcc,

I ran into a simliar problem. It was related to the coversion of the JPG and the spooling size.

Have a look at this thread

In there you will find some code to covert the JPG to BMP on the fly. This should spool better..

Hope this helps.