Extracting OLE Image from MS Access Field, Part 3

In this Microsoft Access tutorial, I will show you how to automate OLE image extraction and deal with common pitfalls during the process, saving images efficiently to a folder from your database. This is part 3 of 3.

Members

In the extended cut, I will show you how to create a loop that processes all records with an image, extracting and saving each one, and then updating the customer table with the new file name, allowing you to delete the OLE object field and recover database space.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Extract OLE Image, Part 2

Links

• DoEvents

Recommended Courses

• Access Developer Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, extract OLE image, Access table, VBA editor, SendKeys function, save image, JPEG format, file menu navigation, debug compile, code customization, DoEvents subroutine, loop through records, image extraction loop, image file naming