Images in Forms -- Database Size Gets Huge

  • Thread starter Thread starter Jonathan Mulder
  • Start date Start date
J

Jonathan Mulder

I"m placing one image in a from. The image is a JPG, and
the size is 319 KB. When I save the database, the MDB
size grows from about 2,700 KB to 17,200 KB! I've
compacted the database, and it still remains the same
size.
Is there something I should be doing to the image prior
to placing in form?

Thanks,

Jonathan Mulder
California Department of Water Resources
Red Bluff, CA
 
Hi,

See if this great article by MVP Tony Toews helps:

http://www.granite.ab.ca/access/imagehandling.htm

I believe MVP Arvin Meyer has a sample database demonstrating
this technique on his site. Look for it here:

http://www.datastrat.com/DataStrat2.html

Find PictureMgr or PictureMgr2K and download the file.
Haven't had to do this myself, but the sample file should
help you get started.

You might also try these links as well:

http://members.tripod.com/accdevel/imaging.htm

ACC2000: How to Display an Image from a Folder in a Form
or in a Report
http://support.microsoft.com/?id=210100

http://www.rogersaccesslibrary.com/download2k.asp?
SampleName='Pictures2k.mdb'
(Watch out for line wrapping on that link)

Good luck,
Jeff Conrad
Bend, Oregon
 
Thanks! I'll check those out!
-----Original Message-----
Hi,

See if this great article by MVP Tony Toews helps:

http://www.granite.ab.ca/access/imagehandling.htm

I believe MVP Arvin Meyer has a sample database demonstrating
this technique on his site. Look for it here:

http://www.datastrat.com/DataStrat2.html

Find PictureMgr or PictureMgr2K and download the file.
Haven't had to do this myself, but the sample file should
help you get started.

You might also try these links as well:

http://members.tripod.com/accdevel/imaging.htm

ACC2000: How to Display an Image from a Folder in a Form
or in a Report
http://support.microsoft.com/?id=210100

http://www.rogersaccesslibrary.com/download2k.asp?
SampleName='Pictures2k.mdb'
(Watch out for line wrapping on that link)

Good luck,
Jeff Conrad
Bend, Oregon




.
Click to expand...
 
Back
Top