Comments on: Store picture from vb to access fieldhttp://itknowledgeexchange.techtarget.com/itanswers/store-picture-from-vb-to-access-field/
Wed, 13 Dec 2017 18:55:09 +0000hourly1By: mikessoftwarehttp://itknowledgeexchange.techtarget.com/itanswers/store-picture-from-vb-to-access-field/#comment-49687
Thu, 31 Mar 2005 10:45:33 +0000#comment-49687You will be much better off in the long run if you save the picture to a file and store the path to the file in Access.
]]>By: manu1076http://itknowledgeexchange.techtarget.com/itanswers/store-picture-from-vb-to-access-field/#comment-49688
Wed, 30 Mar 2005 03:55:30 +0000#comment-49688u can store ur images/files in access database using BLOB datatype, but this would inflate the database size. so its always preferred to store the path/url of the image/file into the database.
]]>By: tmalikhttp://itknowledgeexchange.techtarget.com/itanswers/store-picture-from-vb-to-access-field/#comment-49689
Thu, 24 Mar 2005 09:30:12 +0000#comment-49689I am not sure exactly about access but I know for sure that sql server uses image type field to save pictures and oracle use BLOB datatype to save images.

You usually save things like Jpegs and Gifs into a database like access, sql or oracle save pictures in binary. There are a lot of material available over the web for this. Just type in saving binary data to database in VB. You will get a lot of hits in google or yahoo.
good luck.
Malik

]]>By: mejohnsonhttp://itknowledgeexchange.techtarget.com/itanswers/store-picture-from-vb-to-access-field/#comment-49690
Thu, 24 Mar 2005 09:14:59 +0000#comment-49690What I have done is created a text field in a table. Store the location of the picture (c:picturespicture1.jpg) for each record. Create the report but you must have at least one grouping. I stick everything in the grouping. Insert a picture object. It can be any picture; doesn’t matter.

Then on the OnFormat event of the grouping type me.image.picture (name of image object) = me.txtpicture (textfield)
format_count = 1

This takes a very very very long time and if you have lots of pictures, records, etc. even longer. Be patient.

]]>By: csharploverhttp://itknowledgeexchange.techtarget.com/itanswers/store-picture-from-vb-to-access-field/#comment-49691
Thu, 24 Mar 2005 08:42:23 +0000#comment-49691If you need to display the images in the report, and if it is a web-based report, you can very well make use of IFRAME and provide its SRC attribute, the image path that you have stored in OLEDB field. The reason why I am suggesting this option is, because if an option of stored images on predifined location and storing the path in DB is available, it will be overhead to store full image.
]]>By: timallardhttp://itknowledgeexchange.techtarget.com/itanswers/store-picture-from-vb-to-access-field/#comment-49692
Thu, 24 Mar 2005 08:30:16 +0000#comment-49692Storing it as a BLOB is typical (binary)… the reason most people don’t do this is that it inflates the database size a lot.
]]>By: princess8http://itknowledgeexchange.techtarget.com/itanswers/store-picture-from-vb-to-access-field/#comment-49693
Thu, 24 Mar 2005 01:13:00 +0000#comment-49693That would work for the forms but for reporting purpose i would require to store the pic so the the report could pick the picture directly. Awaiting desperate help. Thanks in advance.