Storing and Displaying images thorugh VB using MS-Access database

Zephyr's Avatar, Join Date: May 2008
Newbie Member
I have given a Ms-Access database in which an OLE object field named "Picture" is present. In this field already pictures are stored as a link. No path and file name has been stored in the database. Now i have a task to display those already saved pictures on a form and then save those pictures again in a ms-access database in a binary format.
I don't have any idea that how i will display the pictures from database to a form as there is not path and filename stored in database. Kindly help me in this regard. The code is to be written using Visual Basic 6.0
0
future_boy's Avatar, Join Date: May 2008
Newbie Member
Sorry Dear, no Idea!

I think Shabbir can help u in this.

Unless here he won't say "it shouldn't be in ths forum"
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Take the binary data and store the file into a temp location and then display using picturebox and then when done delete the temp image file.
0
Zephyr's Avatar, Join Date: May 2008
Newbie Member
Quote:
Originally Posted by Zephyr
I have given a Ms-Access database in which an OLE object field named "Picture" is present. In this field already pictures are stored as a link. No path and file name has been stored in the database. Now i have a task to display those already saved pictures on a form and then save those pictures again in a ms-access database in a binary format.
I don't have any idea that how i will display the pictures from database to a form as there is not path and filename stored in database. Kindly help me in this regard. The code is to be written using Visual Basic 6.0
There is no binary data available. I have given a d atabase in which already pictures are stored as link. No path and filename has been stored in the database. I have to view those pictures on a form. But i have no idea how i will show those pictures on a form as there is no file name and path stored in the database
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Quote:
Originally Posted by Zephyr
There is no binary data available. I have given a d atabase in which already pictures are stored as link. No path and filename has been stored in the database. I have to view those pictures on a form. But i have no idea how i will show those pictures on a form as there is no file name and path stored in the database
What do you mean by links?
0
Zephyr's Avatar, Join Date: May 2008
Newbie Member
There is an option in ms-access database which allowes to store pictures as a link in OLE btype field. In a table a picture can be stored in a photo link. This option is present in Insert menu---> object. Window appears which contains two options. 1- Create New 2- Create From File. When Create from File option is checked the link option appears. This link option saves picture as a link object. The database which is given to me contains pictures as a link object and there is no field for path and filename of a picture.