take photo and add to access database

Posted on 2014-08-07
Last Modified: 2014-08-08
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.
Question by:LJShepherd
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    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:


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


    Author Comment

    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.


    LVL 56

    Accepted Solution


     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:

     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.


    Author Comment

    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.



    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    PaperPort ( is among the most important applications that I run on my Windows computers. I use it every day, for nearly all of my document and photo scanning, as well as most of my…
    This article shows how to convert a multi-page PDF file into multiple image files, with one image file created for each page of the PDF. It does this by utilizing an excellent, free software package called GraphicsMagick. The solution is amazingly s…
    The goal of the tutorial is to teach the user how to use the cropping tool and to straighten there photos so it does not look tilted. You will choose which photo you want to edit, crop it to you liking and make it straight.
    The goal of the tutorial is to teach the user what gradient filters are and how to use them. When you have a photo and some part of the photo is either over exposed or under exposed, you use a gradient filter to help mask the need to touch up th…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now