Report with photos using memory?

[hmanvel]

I have built a report which uses a table that accesses photos via a text field in a table, which indicates the loction of the .jpg file on my hard drive. Got it working well. There are 10 records per page, I am using it for an inventory identication sticker which includes a small photo of the part as well as part no. etc. Printing on Avery stickers. When I open the report, page 1 displays quickly with little fuss. But as I advance to further pages, it takes longer and longer to display. Eventually around page 5 or 6 I start hearing lots of disk accessing, like swapping memory or whatever. And printing a page at that point (page 5 or 6 for example) takes forever, and some of the photos are missing on the printout. It seems like Access is loading every photo into memory prior to the page I am trying to look at and/or print, and eventually there's not enough memory to perform the printing. Is this possible? If so is there any workaround that would release all this unused data from memory?

 

[scalextric59]

What is the size of your pictures? Reducing the dimensions does not reduce the size.
I have worked with reports that show 15+ pics (around 20K each) per page without problems.

 

[Simon_MT]

Your images should be no more than 600 pixels and up 100Kb average 20-50Kb and I use a SubReport for the images.

Simon

 

[hmanvel]

Thanks folks. That was the problem, file size. It's working now with smaller photos. HM.