Results 1 to 5 of 5
  1. #1
    ksammie01 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2013
    Posts
    13

    Removing images from the database

    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

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,643
    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.

  3. #3
    ksammie01 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2013
    Posts
    13
    so, thing is, someone designed the DB, and embedded the images., as OLEs.
    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

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,643
    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.

  5. #5
    ksammie01 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2013
    Posts
    13
    Quote Originally Posted by June7 View Post
    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.
    Awesooommmmmmmmmmmmmeeeeeeee

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to view images in a database.
    By Samari in forum Access
    Replies: 1
    Last Post: 04-03-2012, 06:16 AM
  2. Removing Security form 2003 Database
    By schmidtbb in forum Security
    Replies: 4
    Last Post: 03-13-2012, 01:12 PM
  3. Replies: 4
    Last Post: 12-13-2011, 08:31 PM
  4. Removing all carriage returns from a database
    By Yesideez in forum Access
    Replies: 2
    Last Post: 06-26-2011, 09:55 AM
  5. removing security from not my own database
    By zomas in forum Security
    Replies: 1
    Last Post: 08-01-2010, 10:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums