hotfix http://support.microsoft.com/kb/827983/en-us

[mdullni1 via AccessMonster.com]

I am developing an adp report that loads a different picture for each record.
I am using image object, setting the .picture to the external file path of
jpg file in the group header for each record. Besides the load of each
picture being slow, I also was getting this message during development
(usually when applying/changing the source object on a subreport) "There
isn't enough memory to perform this operation. Close unneeded programs and
try the operation again."
I installed hotfix 827983 (which we had to get sent to us by an MS tech), but
it made the report even slower; in fact, I can only load one record, when I
try to load all the records (~120), it hangs. We tried to system restore to
before the hotfix, but the restore failed. We tried replacing the files the
hotfix says it affected, and we uninstalled and reinstalled officeXP, but I
still have the problem created by the hotfix. We even imported the report
into an adp on other system that did not receive the hotfix but the problem
persisted there as if the hotfix corrupted the report itself. Now that
system is experiencing slowness. I have seen Leban's solution for converting
from jpg to EMFand tried applying that but it did not fix whatever the hotfix
did.

Does anyone have experience with this hotfix?

Thanks,
Peg

 

[Sylvain Lafontaine]

There have been some reports in the newsgroup about problem with ADP 2002
since SP2 for Windows is out.

Maybe you could try with Access 2003 instead of 2002. However, when dealing
with images in a report, you shouldn't expect a miracle solution.

Another possibility would be to try DBPix. I don't know if it will work in
your case but it can't be worse than the Image object that comes standard
with Access.

 

[mdullni1 via AccessMonster.com]

Thanks for your response. I actually had a couple of bugs going on
simultaneously and have worked them out. I resolved the memory bloat using
Leban's jpg to emf conversion code (thanks Steven!). It takes about 2.5
minutes to load 120 records (i.e. 120 different pictures), but when they come
up they are there with little delay while scrolling and NO loading image
message. I think this will do for now. I would like to get the load time
reduced but will live with this.

Thanks,
Peg

There have been some reports in the newsgroup about problem with ADP 2002
since SP2 for Windows is out.

Maybe you could try with Access 2003 instead of 2002. However, when dealing
with images in a report, you shouldn't expect a miracle solution.

Another possibility would be to try DBPix. I don't know if it will work in
your case but it can't be worse than the Image object that comes standard
with Access.

I am developing an adp report that loads a different picture for each
record.

[quoted text clipped - 28 lines]

Thanks,
Peg