MS Picture Manager with MS Access 2007

Hello Experts - I hope you can help me out again.

I am using MS Access 2007.
The database is going to store photos of posters for a poster contest.
Users will vote on the poster.

On the MS site, it says to use OLE to link to either jpg or gif. It does this using MS Photo Editor.
http://office.microsoft.com/en-us/access-help/store-images-in-a-database-HP005280225.aspx


Of course, Photo Editor is no longer available. I have MS Picture Manager, but using it gives me the error "Package" instead of the bitmap image I should be seeing.

My OS is XP and it is a work laptop so I have to do it on this laptop.

How can I make the OLE work? I want to store the pictures in the database because I'll be moving this to our NAS and it is easier to move this way.

Thank you,
Steph M
LVL 1
Steph_MAsked:
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.

David Johnson, CD, MVPOwnerCommented:
Bitmaps only I'm afraid.
Don't  download this as it only downloads MS Office 2003 Service Pack
 I did find a source of picture manager http://microsoft-office-picture-manager.apponic.com/download/ 

BE VERY CAREFUL on installation so you don't get the included garbage.
1st screen go to advanced and unselect from the bottom up, remaining screens select decline.
then you will get the download to start.
 It only downloads Office 2003 Service Pack.
0
Jeffrey CoachmanMIS LiasonCommented:
Yes OLE was never a good platform for storing images.  You say that you ae using Access 2007.
If so then you can use the Access 2007 database format, then insert the image into a "Attachment field"
This will display the record image in a form or report when you insert that attachment field.

But anytime you "Store" an image in Access it creates bloat.
The more standard approach is to store the "Path" to he image instead.  Here is a sample
Access-BasicLinkFormReportImages.mdb
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
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.