Insert jpg files into Microsoft Access 2000 mdb

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Gevorg Nersesya
    New Member
    • Oct 2010
    • 1

    #1

    Insert jpg files into Microsoft Access 2000 mdb

    Hello everybody,

    I have a lot of jpg image files and would like to store them in Microsoft Access 2000 mdb database. I am inserting the images into the database without any problems. But the size of mdb grews unlogically.
    Look, if I store any jpg file with 140kb the size of mdb grews 3.7MB, if I insert file with 195kb the mdb file grews 5.5MB, if I insert the file with 10kb size it grews 348KB.
    I tried to insert images by two ways. First I tried with opening the file in Corel photopaint and with copy-paste combination insert into database. And the second way just pointing the cursor on the file and carring it into the database.
    Is their any other way to insert the images into the mdb with the exect image file size?
  • nico5038
    Recognized Expert Specialist
    • Nov 2006
    • 3080

    #2
    Check: http://www.jamiessoftware.tk/article...ingimages.html and especially the BLOB part.

    Nic;o)

    Comment

    Working...