csmart2301
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
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.
ASKER
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
Clint
You're welcome. Glad to help and thank you very much for the points with the "A" grade!
Happy computing!
Nelson
Happy computing!
Nelson
ASKER
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.