Pictures In A Database

  • Thread starter Thread starter Crispy
  • Start date Start date
C

Crispy

I have posted a few questions and got some very interesting replies about
how to place pictures into a 1600 record database. That means I need to
insert 1600 different pictures...!!!! Each of the pics I have is only about
30K.

Problem of course that by using an OLE box and even "linking" the pictures
from a directory on my HD, I get enormous bloat!

The issue I have is that many of the responses are quite technical and, to
be honest, as a newbie at Access, I am unable to write functions etc....

I have to believe that Microsoft would have expected people to put pictures
in a database!

Anyhow - Given that, what I am saying is, is there a layman's way, and an
easy way, or an easily understood way in how to have one picture per record
in a databse without resort to some convuluted programming or table trick,
and to avoid the bloat?

If anyone has any smart ideas, it will be greatly appreciated.

Regards
 
Try searching this newsgroup and/or Google.com on the topic. There's a
wealth of info about leaving your pictures out of the database and pointing
to them to load-when-viewed.

Good luck

Jeff Boyce
<Access MVP>
 
I received help from someone on this newsgroup on this a
month or so ago and it truly saved my project. It really
doesn't require a lot of programming help - just a line
or two of code in the form or report you want to view the
picture in. The difficult issue was having a way to
identify the photos to the record they belonged to. Can
you tell me a little more and I will try to help you.

Margaret
 
Hi Margaret

I am having the same problem that Jeff did, I need to save one picture per record. Each picture is of a product and each record has information for the product such as pricing, dimensions, vendor infomation. Can you tell me how you where able to save/insert/import each picture

Thanks so much
Mari

----- Margaret wrote: ----

I received help from someone on this newsgroup on this a
month or so ago and it truly saved my project. It really
doesn't require a lot of programming help - just a line
or two of code in the form or report you want to view the
picture in. The difficult issue was having a way to
identify the photos to the record they belonged to. Can
you tell me a little more and I will try to help you

Margare
 
Back
Top