linking photos to record?

[Susan]

Spurred on by recent events, I am making a household inventory database and
would like to include a photo of each item (each record) to be displayed when
the record is showing in the form. I know the best way is to store the photo
separately from the database and link it to the appropriate record for
display. I want to store both the database and the photos (in separate
folders) on a CD so I can keep it away from home (wouldn't do much good if
the CD goes up in flames or floats away with the house!) My problem is that
I don't know how to actually create the link between the photo and the
database record. On the other hand, since I'll be storing the photo on the
same physical media as the database itself, should I just go ahead and embed
the photo rather than link it? Hope I'm making sense....

I searched this newsgroup and found an article by Larry Linson, but I'm
sorry to say that it didn't make a whole lot of sense to me (this is my first
effort at photos in a database). I'm using Access 97. Can someone give me
SIMPLE instructions on how to do this?

 

[Tom Wickerath]

Hi Susan,

A couple of choices:
1.) Upgrade to Access 2003. The sample Northwind database includes an
example of storing employee photos external to the database. However, I do
not think the method that is used can be employed with Access 97.

2.) Try the demo ActiveX control marketed by Ammara.com. You can download a
trial version that gives you 30 days to test drive it. The DBPix ActiveX
control allows you to store images within the database, without the overhead
penalty due to OLE embedding. While I have no personal experience using this
control, Stephen Lebans, a highly recognized MVP for Access, just recently
gave this control a "thumbs-up".

http://www.ammara.com/index.html

By looking at Ammara's web site, it's not totally obvious to me if their
control will work with Access 97. For example, their readme file only
includes the following:

------------------------------------------------------------------------
SYSTEM REQUIREMENTS
------------------------------------------------------------------------

Windows XP. 2000, NT 4.0, ME, 98, 95 or later.
Minimum 8-bit (256) color display (higher color-depth strongly recommended)

They do have an e-mail address posted for support. It is: (e-mail address removed)


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Spurred on by recent events, I am making a household inventory database and
would like to include a photo of each item (each record) to be displayed when
the record is showing in the form. I know the best way is to store the photo
separately from the database and link it to the appropriate record for
display. I want to store both the database and the photos (in separate
folders) on a CD so I can keep it away from home (wouldn't do much good if
the CD goes up in flames or floats away with the house!) My problem is that
I don't know how to actually create the link between the photo and the
database record. On the other hand, since I'll be storing the photo on the
same physical media as the database itself, should I just go ahead and embed
the photo rather than link it? Hope I'm making sense....

I searched this newsgroup and found an article by Larry Linson, but I'm
sorry to say that it didn't make a whole lot of sense to me (this is my first
effort at photos in a database). I'm using Access 97. Can someone give me
SIMPLE instructions on how to do this?

 

[Susan]

Thanks for the info, Tom. I'll check out the demo. I may also be upgrading
to Office 2003 one of these days. I appreciate your response.

 

[FinRazel]

I don't know if this will work in Access '97, but I would make a hyperlink
field in one of my database tables. You can hyperlink to web pages, but you
can also link to files on your computer (or CD as the case may be). You will
either have to write the full address of the file into the cell, or you may
be able to right-click the cell to insert a file using windows. This also
works for tables in excel.

 

[ETZT40]

Hi Susan

I had the same idea as you which came to mind during the holiday time. I
thought Access 2003 will do the job. I am not acustom to databases at all. I
read your
request and thouht I will ask if you have now properly programmed a
household inventory which shows photo's online as well as in reports.

Please reply,

Etienne