take photo and add to access database

I'm developing a visitor database in Access 2013 and want to know if anyone knows if it is possible to take a photo from the onboard camera on the PC and place it in a designated field which will then print on a visitor badge report.
LJShepherdAsked:
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.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Yes, you can.  There are a wide range of options.  In the general, the usual approach is to have the camera save the pic as a file on disk, then using an image control in a form, point to that file.   In the DB, you'd only store the description and other attributes (ie. "Date taken"), and a path to the picture.

 I would also suggest you take a look at:

DBPix,
http://www.ammara.com/dbpix/access.html

 Which makes it simple to manage and use pictures within Access.   You don't have to have this, but it makes it easier.

Jim.
0
LJShepherdAuthor Commented:
Hi Jim,

Thanks for your post. I will take a look at DBPix. Do I take it that I can use an access button to prompt the camera to shoot and then get DBPix to process the photo and store it in an access table ready to print on the visitor badge?

If I don't respond in the next few hours it is because I am in the UK and will not pick up any responses until tomorrow morning.

Cheers

Les
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Les,

 The usual approach is to put up a message "Ready to accept picture", then have someone press the button on the camera.

  DBPix, Access, etc, are all designed to use the acquisition methods built into Windows and that method (and there are several) along with the camera and it's driver determine what you can do.

  So my advice would be to keep it as simple as possible.  However, yes you can do exactly that.  Take a look at:

http://www.ammara.com/support/samples/access-wia-camera-control.html

 WIA is however an old technology, but still supported in newer versions through WPD, so everything in DBPix should still work fine.  

 They offer a free download, so I would download and try the sample code with your camera and see if you can get what you want.

Jim.
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
LJShepherdAuthor Commented:
Excellent Jim,

Thank you. I'll give it a blast and see how I get on.

Meantime I'll accept your answer and award the points.

Cheers

Les
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
Microsoft Access

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.