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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Skiran
    New Member
    • Oct 2006
    • 5

    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)?
  • noviceadmin
    New Member
    • Feb 2008
    • 21

    #2
    Halo dear
    Have you succeded in your action
    plz tell me
    Actually I am using VB 6.0 + ms access + crystal report 4.6.1.0

    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


    Thanks

    Bye

    Comment

    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119

      #3
      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.

      Comment

      Working...