ConvertPics_OLEtoExternal.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
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 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
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |