How to insert JPG into database

[mcaron]

Hi all,

I'm building an application that will store JPG's. Using ADO how can I affect the OLE Object field in my Access database with the content of a JPG. In other words I want to be able, once the JPG stored into the database, to view the JPG directly from the database without it being on a drive somewhere. I'ved structured my database with an OLE Object field. Is this the right kind of data field? If not what is the right one to use? Can anyone help me please.

Thanks,

Miguel

[Chris Eastwood]

If you look on this site under database / ado you'll find a link to the MSDN article for using GetChunk and AppendChunk with ADO.

You'll need to store the JPG locally once you've retrieved it from the database (unless you want to really get complicated).

Look here : http://codeguru.developer.com/vb/Database/ADO/index.shtml

Chris Eastwood

CodeGuru - the website for developers
http://codeguru.developer.com/vb