Running out of memory while printing reports.

  • Thread starter Thread starter msnews.microsoft.com
  • Start date Start date
M

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.
 
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
 
Back
Top