Images in Forms -- Database Size Gets Huge

[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

 

[Jeff Conrad]

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

 

[Jonathan Mulder]

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




.

 

[Jeff Conrad]

You're welcome.
Glad to help.

Jeff Conrad
Bend, Oregon