Here is my challenge: An oversized database with well over 3000 entries for items in an inventory. The bulk of the size is, of course, the embedded images for each entry. My task is to reduce the size of the database by linking the images rather than having them be embedded. I also need to fix the database so that future entries are not embedded and start things in the wrong direction all over again. Thanks to your seminar, I have the challenge of the future entries solved. However, I need a solution to relinking thousands of images to existing entries without linking them one at a time. I had thought that there must be a VBA code or macro out there to tell Access to search for and enter image links from the shared server folder and assign them to the proper entries /in bulk/. Anything you can give me to help with this monster would be most appreciated.

---

Reply from Richard Rost:

If the filenames of the embedded images are the same as the filenames of the images as they're stored on your server, then you MAY be able to get the name of the file from the embedded OLE object, see if it exists on your server, and if so delete the OLE object and set the filename in a text field. MAY. I've never done this before, and I would honestly have to research and test it for you to see if it's even possible. It's certainly not something am going to have the time to look into any time soon, but if you want to submit it via my TechHelp page, I'll see if one of my techs can research it for you.