Avatar of arobe12
arobe12
 asked on

Insert photo to MS Access Database by MS Access Form

I make a small program like human resource by MS Access. I want to make a form for inserting information about human regard human photo. So how to make that form ( insert OLE Object Photo) to database and display it on the form.
Microsoft Access

Avatar of undefined
Last Comment
rockiroads

8/22/2022 - Mon
John Mc Hale

If you can possibly avoid it, stay away from inserting photos as OLE Objects.

Your best strategy is to store the photo files in their native JPEG format as binary images in OLE Object field of table and write some code to load/save images to table.

You can use an image control to display them.

ASKER CERTIFIED SOLUTION
jjafferr

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
jjafferr

if you want to embed the pictures in your Table,
like fredthered said, it is NOT a good idea to save them as OLE objects, but as BLOBS,
the following link show you the steps to store the files, then how to show them:
https://www.experts-exchange.com/Databases/MS_Access/Q_21976256.html


jaffer
rockiroads

I think jaff and fred has pretty much covered the options

But some reading that's good - http://www.jamiessoftware.tk/articles/handlingimages.html
For SQL Server or some other decent db, blobs would be the best move
For MSAccess I would go for storing paths, remember access has 2gig limit
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck