Running out of memory while printing reports.

[msnews.microsoft.com]

We have a small database of ~400 records that have in each of them a field
that is a pointer to a graphic file (jpg). When we try to print a report
for all records (1 page per record) with each record having the linked image
on the page, we run out of memory. I've tried to break up the printing by
changing the record source to a query that queries 50 records at a time and
that works up to a point. Printing records 250-300 (again record source
being the query which is limited the result set to 50 records), we get the
out of memory issue again. I've tried it on 2 computers, same thing (P4,
1Gig Memory).

Any help would be appreciated.

Thanks.

 

[Larry Linson]

This is a known problem; Stephen Lebans used to have an example at his site,
http://www.lebans.com, of a simple way to convert the .jpg files to .bmp
before using them and, thus, avoiding the memory leakage you describe.

Larry Linson
Microsoft Access MVP