Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - ConvertPics_OLEtoExternal.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: ConvertPics_OLEtoExternal.mdb
    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/


Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down