ConvertPics_OLEtoExternal.mdb

This sample db offers remedial action for Access databases suffering heavy 
bloat on account of direct embedding of images in OLE fields.

For carrying out the conversion, click the top button in main Switchboard to open 
the form F_PicsEmbeddedInOLE. On this form, click the command button for 
conversion. This will convert all images embedded in OLE fields into separate .jpg 
files and store the same in a newly created folder named PicFolder (in the same 
directory that holds the sample db). Simultaneously, the paths of these externally 
stored files get recorded in the field named ImageFile (in the source table named 
T_Pics).

For slide-show display based upon paths of externally stored images (created as 
above), click the second command button on the main Switchboard.

For handling an existing table having images embedded in OLE Fileds, import the 
table into sample db. Rename the OLE field as Pic, ensure an Autonumber primary 
key  named ID_No, and add a text field named ImageFile. Rename the table as 
T_Pics and proceed as above.

(When satisfied with external storage, existing OLE field in the table can be 
deleted - for eliminating Bloat)
 
    CAUTION - 
        (a) This program uses Microsoft Photo Editor. It may please be ensuredthat 
correct path for file PHOTOED.EXE is specified in click event of CmdCopy in code 
module of form F_PicsEmbeddedInOLE .
        (b) This sample db as well as the accompanying Blank.jpg, should be kept in 
the same folder. 
                
5 - Versions - Access 2000
      References - OLE Automation, DAO 3.6, MS Scripting RunTime

Download Access 2000: uploads/37/ConvertPics_OLEtoExternal.zip