By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,489 Members | 1,932 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,489 IT Pros & Developers. It's quick & easy.

MS Access reports craches...

ses
P: 5
Hello,

I 've created a report with a lot of images (jpg 2340x1660 pixels).
They are maps,I cannot remove them or decrease the dpi.

Now I've start to add data in the database, but when access loads more than 30 pictures crashes.

Is there any way to unload them every time I leave the page they are inserted?

Thanks in advance

ses

PS. I've not tried to make then GIF, its time-consuming.
Jan 15 '07 #1
Share this Question
Share on Google+
4 Replies


nico5038
Expert 2.5K+
P: 3,072
When you use A2000, then make sure that the Service Packs have been installed as without them the .mdb will bloat :-(
SR1a/2:
http://support.microsoft.com/default...;en-us;Q276367
SR3:
http://support.microsoft.com/default...b;EN-US;326585

Nic;o)
Jan 15 '07 #2

ses
P: 5
ses
Thanks for your answer, but I've already tried that.

I tried to view the last page the report in 3 different PC's (2 with SP3) but the result was the same.

ERROR 2114, when the images loaded are about 25 MB (it depends, probably due to each system resources).

At this time I use a form/filter to load 15 records in each report and print them, but I don't want that.

Is there any way to manipulate system's memory through VBA?

TIA
ses
Jan 16 '07 #3

nico5038
Expert 2.5K+
P: 3,072
Did you try to write the report to a PDF "printer" ?

Nic;o)
Jan 16 '07 #4

ses
P: 5
ses
The same...MS Access has to load all the images while printing...
Thanks for ur tries to help!
Jan 16 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.