469,950 Members | 1,855 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

store Images as OLE Object in Access OLE Object Field using ADO in vb6

I am handling a large-scale project entitled as MIS (Marketing information System). I am using Vb 6 as front end, Ms Access as back end and Crystal report 8 as reporting tool.

1) In the project i am required to save customers image to database, and it should be shown in individual customerís report, which will include that image. I had taken OLE field in the database to save images. I had taken Common dialog box control to select image and display it in OLE control, but i don't know how to save the OLE controls image to database. i am using ADO object to access the database. How could I can save and retrieve the image from database? Is it possible to save images by using other controls like Picture box or image control in the form? I want to save image as bitmap in the database.

2) The size of project is very large then it is useful to store image to database? Will it make it slower to access database?

3) Saving path of image in database will make any difference? If i do so then how can show the images in report (Crystal report 8)?
Oct 30 '06 #1
2 2912
Halo dear
Have you succeded in your action
plz tell me
Actually I am using VB 6.0 + ms access + crystal report

My images are stored as path in tables
using VB Data Control(DAO) ,,,is it possible to display images using above configuration in crystal reports


Mar 18 '08 #2
8,127 Expert 4TB
Better store the image itself not the path of the file . When used in crystal report the image will be displayed directly. But i am not sure with the version of crystal report you are using. I have never used that version.
Mar 18 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Karen Grube | last post: by
2 posts views Thread by Tim Zych | last post: by
6 posts views Thread by Rudy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.