How do I link to a folder in Access 2003?

[nysteve56]

I'm creating an Access database. I have folders on my network at work that
are photo archives. I want to create a field in my database where I can input
a hyperlink to these folders for each database entry. I can link or embed the
actual photo files, but one folder may end up with 100 photos, and I don't
want to embed or set up links to all 100 of them. I figure a link to the
folder itself would be much more convenient. How do I set up the hyperlinks
to the folder?

 

[Rick B]

I think the following will help you...



Storing Pictures
Storing pictures in an Access database is very inefficient, and will lead to
database bloat. Store your pictures in a folder on your hard drive. In the
database, store just the name of the picture, i.e. picturename.jpg, in a
regular text datatype field. To display the picture, use an Image Control.
Set it's Picture property to the field that stores the picture path.

[ImageName].Picture = "c:\foldername\" & [FieldName]

You can do that in a Form's Current event, or a Report's Detail Format
event.



www.rogersaccesslibrary.com has two small sample databases: "Pictures.mdb"
and
"PicturesLoad.mdb" which illustrate how to handle pictures



Another link related to pictures:

http://www.granite.ab.ca/access/imagehandling.htm