[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2024
  • Last Modified:

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.


datab4.mdb
0
csmart2301
Asked:
csmart2301
  • 3
  • 3
1 Solution
 
thenelsonCommented:
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.
en.wikipedia.org/wiki/Binary_large_object  General discussion about Blobs
www.lebans.com/loadsavejpeg.htm  Free code to use blobs in Access
www.ammara.com/  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.
www.jamiessoftware.tk/articles/handlingimages.html
0
 
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.
 
0
 
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.

Clint
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
thenelsonCommented:
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.
0
 
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.

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

Happy computing!

Nelson
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now