Show Long binary data as image in Access Form

I have been asked by one of our sister companies to help with converting an old database I was given the mdb and it has images stored as long binary data however I have no idea how to place them on a form.

I have included a sample. I was told the images are jpg files of plants but I get an error

A problem occurred while Microsoft Office Access was communicating with the ole server or ActiveX Control.

If you can get this working in this sample i can take it from there.

Thanks in advance.

close the OLE server and restart it outside of Microsoft Access Then try the original operation in MOA.

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.

I would recommend you try the ammara add in for displaying images.

Here are references for storing images within Access as Blobs. Does not create bloat.  General discussion about Blobs  Free code to use blobs in Access  Excellent addin to support image blobs Costs $100-300

And here is an article about the comparable merits of the three different image storage methods.

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
csmart2301Author Commented:

Thanks for the advise however i do not have a $100 to $300 budget for this problem also Not concerened about blot as the database will not be growing.
I am not trying to get the images out i only want to be able to view them.
There is an example db with the question there has to be a way to view these images without add ins that is all i am looking for.
I guess i would settle for moving the images out to jpg or bitmap if someone knows the code but that is not my first choice.
Also i can't open your first link it seems broken.
csmart2301Author Commented:
Ok tried the first link again and it loaded this time

Downloaded the example on that page and was able to paste a blob in to it's recordsource and view it. so they are jpg.

however getting that code to work with my recordset still seems taxing.

If there are anyother ways i am open so sugestions.

The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Handling blobs and jpg in Access is cumbersome and complicated. That is why I recommended the ammara software as it it install and use. Using the Lebans code will toke some work.
csmart2301Author Commented:
I used the Lebans code download and got all the files saved outside of the database and they are now workable. though this is a grate help it still didn't solve the original question. But thanks you got me moving forword again.

You're welcome.  Glad to help and thank you very much for the points with the "A" grade!

Happy computing!

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.