How do I insert a photo in a database record for that record only

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I want to put a different picture into an individual database record in
Access 2007. Can anyone tell me in simple steps how I can do it. Thanks
 
My recommendation is "Don't". Pictures rapidly consume the limited database
storage available to an Access user.

Instead of actually storing the picture in your database, store the picture
in a secure location on your computer or network. Then store a pointer
(filename) to that picture in a text field in your database.

With this information, you can either hyperlink to the picture, or set the
Picture property of an image control to the filename.

HTH
Dale
 
Thanks Dale. I will do that. Can you help me in inserting the photo? I can
get it to show on all records but not a single record. When I get close on a
single record, I get grey diagonal lines acrosss the photo. Being a bit of a
novice I need step by step help. I also read in a discussion that photo size
matters.
 
Back
Top