How to Insert image in Table Field of MS Access 2003

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lwannwayoo
    New Member
    • Mar 2010
    • 5

    How to Insert image in Table Field of MS Access 2003

    Hi Everybody!
    I have a database in Microsoft Access 2003 and I want to insert image in my Table Field. How can I don it??. I use OLE type but when i insert image to that field
    only the word "Package" appears. I want to insert image in that field and load it
    using ADODC in my Visual Basic form. I have already tried but an error occured in loading Image field of my Access Database. Can anyone solve my problem??
    Hope the best answer for you.
    Regards,
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    Storing images in tables in pre-2007 Access is a very poor idea! Take a look at Dev Ashish's article on the subject. It gives some better ideas for handling this task:



    Welcome to Bytes!

    Linq ;0)>

    Comment

    • ADezii
      Recognized Expert Expert
      • Apr 2006
      • 8834

      #3
      A very efficient Method of storing Images (Byte for Byte) in an Access Table is by storing them as BLOBs (Binary Large Objects).

      Comment

      Working...