vba access 2007 insert an image into a table RRS feed

  • Question

  • Hi guys, I have an Access 2007 form with 1 image that changes form user to user and all i need is to save for each user the picture in 1 field of 1 table. In each case the table only stores one and one only picture so thats why we decide to go for storing it in the database.

    So I need to store the picture in a database field. Have read about the BLOBS and some other stuff that doesn't work so I decided to go for simply converting the file in an array of bytes and saving it in the database. The conversion was ok, I created a table with OLE object datatype field but when i try to execute the CurrentDb.Execute insert I realize the command doesn't accept other things but strings...

    How can I simply and easy insert one little picture in a Access 2007 database using the Access 2007 VBA... or... save the byte array?


    • Edited by dpolanco Friday, September 6, 2013 2:06 PM better name
    Thursday, September 5, 2013 10:15 PM

All replies