Access 2013 database - How to import a jpeg file into a field.

My OS is win 7 Prof 64 bit and I have developed a small contact database.  one of the fields is a field to impot the jpeg picture of the contact.  
Firstly, I have set the field as an attachment.  is this the right data type to import a jpeg file to display on the form the picture of the contat.
and finally, I have this field in the Form.  How do I set the field to say point : to the C:\ directory, and I will navigate to where the jpeg file is located, highlight it, and then import it to the Form.
Thank u for your advise.
jegajothyretiredAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
Did you followed "Manage attachments by using a form" - "Attach a file" from https://support.office.com/en-us/article/Attach-files-and-graphics-to-the-records-in-your-database-bced3638-bfbc-43f0-822d-374bca2e6b40?

Like:
...
3. Click the View Attachments button (the paperclip icon) to open the Attachments dialog box.

4. In the dialog box, click Add.

5. The Choose File dialog box appears.Use the Look in list to navigate to the file that you want to attach, and then click Open.

Repeat steps 4 and 5 as needed to attach more files.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You might consider using an Image control instead, and storing the full path to the image file in a field in your table. You can then "bind" the image control to that text field, and Access will display the image at that location. That's normally easier that using the Attachment type in Access.

If you need to allow the user to select an image, you can use the FileDialog to allow the user to locate the file, and store the value in your table field.
1
jegajothyretiredAuthor Commented:
thank u everyone for your inputs.  Looks complicated to me.  How can I do the easier route, of just pasting the image onto the field on the Form.  This will save me of moving the attachments together when I move the access file to another user in a different pc or location.  Thank
0
Jeffrey CoachmanMIS LiasonCommented:
I'm with Scott.

Other reasons:

1. You state that images of "contracts" will be stored...
I strongly advise to to save your contract "Scans" to PDF's.
jpg are editable file formats,...so an attached contract can be easily opened and "modified"
PDF's (at the most basic level), ...are a lot harder to modify.
Also, with these images stored in an Access db, ...they are less secure than files stored on most servers.

2. Though the attachment datatype will minimize bloat, ...it does not eliminate it.
So if you plan on storing a lot of common hi-res images (>=5Mb), you may quickly bloat the db and notice performance issues.

3. The attachment datatype is not currently supported by any other Database system.  So when the time comes to upgrade to MySQL, SQL Server, ...et al), ...you will be forced to find a way to "unattach/extract" these files anyway...

4. If you plan on displaying these images on a form or report, ...note that there is no easy way to display more then one image/attachment per record.

5. Although displaying many 'Linked" images may still present performance issues, ...using "attached" images will only make these matters worse.

6. Using this datatype without alerting you System Administrator can result in "Multiple" versions of the same image file. (...the original, and the attached one.)
If a change is made to the original (source), ...the attached file will NOT be updated automatically (and vice versa)

I have a simple "linked image" sample db, ...I will try to modify it to display PDF's...

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jegajothyretiredAuthor Commented:
thank u.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Office 365

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.