So, i have a database, with images saved as OLEs.
i want to remove the images, store them else where, and then instead save links to the images, that am planning to store else where, and not in the database.
Is there a way i can do that??
Thanks
So, i have a database, with images saved as OLEs.
i want to remove the images, store them else where, and then instead save links to the images, that am planning to store else where, and not in the database.
Is there a way i can do that??
Thanks
Google: Access vba export ole image
http://www.lebans.com/oletodisk.htm
http://bytes.com/topic/access/answer...s-folderfolder
http://support.microsoft.com/kb/103257
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
so, thing is, someone designed the DB, and embedded the images., as OLEs.Google: Access vba export ole image
http://www.lebans.com/oletodisk.htm
http://bytes.com/topic/access/answer...s-folderfolder
http://support.microsoft.com/kb/103257
so now the DB is growing alot, and i want to remove the images, and store them somewhere, and then just put links to the images..
The about method, seems to just extract the images, into a folder, without removing them entirely from the db. there are over 1000 images
The images are saved in an OLE field in table?
Export the images, save the path to a text field in table. Delete the field from the table.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.