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?
Thx