save pictures / screenshots (bitmaps and jpegs) in access database

[mcla]

hi all
i have a question,
im working with a ms access 2003 database and vba
what i need to do is to save pictures / screenshots (bitmaps and jpegs) in the database
first i would need to save these to a array though (because application specific) and then save them into a database
does somebody know how i can save them in a array and database?
thanks a real lot
:)

[ScaryBinary]

Hooo boy, I don't know. I remember using something like 'GetChunk' and 'AppendChunk' to write binary files to database fields, but that was Access 2000. Look through Access 2003's Visual Basic help files for those functions and see what comes up. You might also look through the help files for "BLOB" (Binary Large Object). Here's an article for Access 2000, maybe it will lead to some Access 2003 stuff....

Access 2000 BLOBs (MSDN) (http://support.microsoft.com/?kbid=210486)


I don't know how you'd create an array in Access and assign a file to the elements. Maybe you could make an array of type File or something, then read in the files and assign them to the array?

I don't really have any advice other than poke around on the internet and at http://msdn.microsoft.com for some tips.

[ScaryBinary]

Here's a mildly interesting article on image storage in Access:

http://www.ammara.com/articles/imagesaccess.html