Pictures In A Database

[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

 

[Jeff Boyce]

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>

 

[Margaret]

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

 

[Guest]

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