By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,986 Members | 1,522 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,986 IT Pros & Developers. It's quick & easy.

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

P: 5
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
Share this Question
Share on Google+
2 Replies

P: 21
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

Expert 5K+
P: 8,127
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.