Access file size

F

Fredrated

I just added a couple of graphics files (jpeg & gif) to a report, files that
total less than 300k. The access file size jumped up by about 30 meg as a
result!

Is there any way to reduce this to a reasonable size? Compacting reduces
the file size by about 1 meg, as does importing everything to a new access
database.

Thanks in advance for any help.

Fred
 
M

Marshall Barton

Fredrated said:
I just added a couple of graphics files (jpeg & gif) to a report, files that
total less than 300k. The access file size jumped up by about 30 meg as a
result!

Is there any way to reduce this to a reasonable size? Compacting reduces
the file size by about 1 meg, as does importing everything to a new access
database.


Those graphics are converted to bit maps which are stored in
the mdb.

You would be much better off if you did not embed the
graphics in the report. Instead, put the path to the
graphics files in the mdb. Then you can use an unbound
image control and set the Picture property in the Format
event of the section that contains the image controls.
Check here for example files:
http://members.tripod.com/accdevel/imaging.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top