image & memory

[NetworkTrade]

Issue: runtime error due to memory when image is in report Access2003

Have reviewed this issue on this site as well as the helpful links to Leban
site. Report has image each page; the table source contains the pathlink to
the image file and the image displays onformat.

Works well upto X pages and then hits the memory related runtime error.
Have downsized the image file size which increases X but....

Some of the info I reviewed was pretty old...i.e. Access97; and I saw
helpful info for putting the task to the onprint rather than the onformat as
well as a conversion to bitmap format...

But these all seem to be workarounds; is there a formal guideline on the
limit parameters to this? With a guide I could at least limit the size of
the report automatically perhaps to avoid the user having this issue. It
would seem fairly common to have reports with images in this manner. Input
most welcomed. Thanks.

 

[NKTower]

It has all of the symptoms of memory leakage. Not having access to the code,
let me ask whether you are attaching the image to an object?
Set myImageObject = .....
If so, is there some corresponding place where you can explicitly release
the object, eg.
Set myImageObj = Nothing
If it is one image per page, I'd start with the Reports On Page event.

 

[Larry Linson]

If you convert the image file type to .BMP before displaying, I think you
will avoid the problem entirely. And, if memory serves, the example of how
to do so is indeed on Stephen Lebans' site http://www.lebans.com.

There are no such guidelines, so no one can help you there. With a
particular report and specific pictures, I ran into this "brick wall" at 81
records with pictures, but with different data, different size image files,
different type image files, that number would be different.

Larry Linson
Microsoft Office Access MVP

 

[NetworkTrade]

thanks for both replies.... when an MVPer describes it as a 'brick wall'
then I know it is not just me...

will relook at Leban's bitmap work around..... I hope that MS will look
at this issue of jpg images on report pages as it really is a mainstream
issue.

 

[NetworkTrade]

No - you are wll beyond my depth....do alot with Access but know nothing
regarding "loading image dialog" or involvement in Registry.... but you are
the guru... I kind of just stay within the vanilla boundry of the
product....but if this info is at your site I will re-read it because I do
have user that has a report of ~50 pages with an image on each page and it
will not work.... have down sized the image file size but it is still not
reliable....