Steven Mandel
smandel7 at corecomm.net
Wed Feb 12 17:25:00 CST 2003
Thank you Marty, I appreciate it. Steve -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com]On Behalf Of MartyConnelly Sent: Wednesday, February 12, 2003 3:59 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] extract images into files Try either method depending on how` you put the image into mdb it may be stored as Jpeg or BMP, so modify your output file accordingly ACC: Reading, Storing, & Writing Binary Large Objects (BLOBs) http://support.microsoft.com/default.aspx?scid=kb;[LN];Q103257 or via ADO stream object http://www.betav.com/Files/Content/Whitepapers/Using%20the%20ADO%20Stream%20 Object%20to%20Manage%20BLOBs.htm Steven Mandel wrote: >Hi all, > > I created a database when I first started using access and stored images >in >the database as ole objects . After doing a lot of reading , it is suggested >not to do that but rather save the images in a directory and save the name >of the object >in the database instead and then load the object in a form when needed. How >can I extract these images as individual files and save them in a directory. > >TIA , > >Steve Mandel > >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > > > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com