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: http://www.rogersaccesslibrary.com/forum/uploads/37/ConvertPics_OLEtoExternal.zip - uploads/37/ConvertPics_OLEtoExternal.zip
------------- --
Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com
|