Resize Images in Microsoft Access: Using FFmpeg & Paint with VBA - Advanced Developer Tutorial

In this Microsoft Access tutorial, I'm going to teach you how to resize images directly from your Access database. We'll cover two distinct methods for achieving this. First, we'll explore how to use the Shell function in VBA to run FFmpeg, an open-source multimedia handling utility. Next, for those who prefer an approach that doesn't require 3rd-party software, I'll guide you through a technique using SendKeys and Microsoft Paint. This tutorial is designed for both Advanced users and Developers, offering a practical way to manipulate images within Access.

Maya from Eagan, Minnesota (a Silver Member) asks: How can I resize large, high-resolution JPEG files from my photographers to a more manageable size, like 500 pixels across, so that I can easily link them to my Microsoft Access database?

BECOME A MEMBER:

LEARN MORE:

PREREQUISITES:

LINKS:

FFMPEG:

RECOMMENDED COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, resize images in access, resize pictures, ffmpeg, shell, sendkeys, Access VBA Image Resize, Image Manipulation Access, Scale Images Access Database, Access Image Control, VBA Code Image Resize, Batch Resize Access, MS Access Image Optimization, VBA Picture Resize

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[fotiosfotinakis]

This is so... nifty, thanks for the hint, never read through the manual of 'ffmpeg' to know that images can also be resized! Also you refreshed to my mind, the 'shell' (but not shallow) way to do things. Live long and prosper, Rick!!

[petewarby]

I swear go G*D you read my mind.
I was storing images in the new database until you showed us how to link an image to the image object.

I was then using my Raspberry PI to run a program manually to create thumbnails...

And then this YouTube upload came along literally a week later. I was already getting fed up of going on to the PI to do it and this has upload literally dropped in a week later.

After some typos on my part it worked like a DREAM. I'm so impressed with what I've learned from your uploads in the last few weeks. Is there NOTHING you don't know about Access????

Legend.

[Shadow.Dragon]

Richard, thanks for the video! I really like your "automation" tips!

[diababdelkrim]

I will tell you 1000 thanks in Arabic "شكرا جزيلا

We would like a drag drop image + Copy to a specific path + resize. Drag and Drop is the most important.

[rbhnr]

Great tip using ffmpeg. Can you do a video to show how to run the routine on a folder for example that has several images in there. Thank you.

[ayaddaham]

If possible, a link to download the file

[xavierbatlle]

Hi Richard. Perhaps if you requery the control instead the Recordset it also works. Sometimes I use to repaint some control.