Avatar of bcreen
bcreen
Flag for United States of America asked on

In Access 2013, what is best way to 'link' to a photo of an applicant or employee?

I'd like to be able to NOT STORE employee/candidate head shots in my Access 2013 database (back-end) because of the space it takes up.
Can 'links' to the photos stored on a folder on our terminal server or file server be stored in a particular field type in Access 2013 and when that employee's record is loaded in a form, the photo be automatically be displayed?
Microsoft AccessImages and Photos

Avatar of undefined
Last Comment
bcreen

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Hamed Nasr

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Hamed Nasr

On a form add an Image control, Image0
Properties sheet-Format
Picture Type: Linked
Picture: D:\pict.jpg    

In code:
Image0.Picture = text_Field_Containing_ImagePath 

Open in new window

SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Merete

Side idea,
 you could also resize the image? with VSO image resizer since size of these images is the main problem as well.
bcreen

ASKER
Ideas all worked !  Thanks.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes