Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Visual Basic ( VB ) (http://www.go4expert.com/forums/visual-basic/)
-   -   Storing and Displaying images thorugh VB using MS-Access database (http://www.go4expert.com/forums/storing-displaying-images-thorugh-vb-t10949/)

Zephyr 31May2008 10:33

Storing and Displaying images thorugh VB using MS-Access database
 
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

future_boy 31May2008 10:47

Re: Storing and Displaying images thorugh VB using MS-Access database
 
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"

shabbir 31May2008 16:35

Re: Storing and Displaying images thorugh VB using MS-Access database
 
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.

Zephyr 2Jun2008 10:29

Re: Storing and Displaying images thorugh VB using MS-Access database
 
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

shabbir 2Jun2008 13:21

Re: Storing and Displaying images thorugh VB using MS-Access database
 
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?

Zephyr 3Jun2008 08:54

Re: Storing and Displaying images thorugh VB using MS-Access database
 
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.


All times are GMT +5.5. The time now is 01:21.