Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
Printed Date: 23 Jan 2021 at 10:55pm
Software Version: Web Wiz Forums 12.03 -

Topic: ConvertPics_OLEtoExternal.mdb
Posted By: A.D. Tejpal
Subject: ConvertPics_OLEtoExternal.mdb
Date Posted: 09 Jul 2008 at 11:10pm
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 

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/


Email: -

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -