[AccessD] Pasting pictures

Eric Barro ebarro at afsweb.com
Wed Aug 6 17:51:06 CDT 2003


Steve,

The best solution is to store the path in the DB and not store the images in the DB. The path references the image file. The bigger the record the slower your DB will be.

---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steven W.
Erbach
Sent: Wednesday, August 06, 2003 2:09 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Pasting pictures


Dear Group,

We've been called in to finish an already-started Access 2000 application.
It's a database of ergonomic information pertaining to industrial jobs;
i.e., how much lifting needs to be done, how much walking, standing,
stretching, etc. The database contains pictures of the typical functions
performed for the job.

When we got the database in its unfinished state there were some picture
records already stored in a table ( tblPictures ) with an OLE Object field.
When I look at the datasheet I see the "Picture" column filled with the
"Bitmap Image" placeholder.

We entered some new data into the application and added some new records in
the tblPictures table. The pictures were already stored in a Microsoft Word
document. After I figured out how to copy the picture and paste it into the
Picture field, I went and looked at the field in the datasheet. All of the
new images from the Word document have the "Picture" placeholder. The
database has also ballooned by about 1 MB for each picture added to the
tblPictures table.

Each of these images is 322 x 256 pixels, 24-bit color. If I save one of the
pictures as a BMP it'll be about 240-245KB in size. If I convert to a JPG
it's down to 26KB.

If I view the tblPictures table and right-click on the Picture column and
choose Insert Object, I can Browse for either a BMP or a JPG to insert into
the field. But when I'm finished the field's placeholder reads "Package."

My questions: 1) Is there a way to keep the database from ballooning in size
so much. 1 MB per image seems excessive to me, especially since I can embed
a JPG at 26 KB each; 2) What's the deal with "Package" vs. "Picture" vs.
"Bitmap Image"?; and 3) Is there a way to disable the OLE linking feature;
that is, prevent the user from double-clicking the image and opening up
Microsoft Paint or whatever?

Thanks a lot.

Steve Erbach
Scientific Marketing
Neenah, WI

"Eventually, socialists run out of other people's money."
-- Lady Margaret Thatcher


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003




More information about the AccessD mailing list