Automatically Export Pictures from Access Database
Posted on 2011-03-10
We have an access database where all of our staff and student photos are kept. I used a tool to export all of the photos. I would like for any new photos to be automatically exported and emailed.
The database has a table in it named TBL_MEMBERS. There is a field named ALT_ID which has the username for the staff/student. The photo is stored in a field named PHOTO_1. The value shows long binary data. When I exported the photos manually, they were a .jpg
Can someone provide a script that automatically exports newly added photos, names the photo after the username, and then emails the collection of photos?