Others

How to Reduce Access Database Size When Embedding Images

Natalie TaylorNatalie Taylor Nov 2, 2026 868 views

Question details

The user needs to prevent their Microsoft Access database file size from growing unnecessarily large when embedding graphics or images into forms and reports.

How to Reduce Access Database Size When Embedding Images
Product
Microsoft Access
Device & OS
not provided
Scenario
Inserting application images, logos, or large graphics into an Access database or report.
Observed behavior
The database file size inflates rapidly because Access converts embedded picture data into uncompressed bitmap formats by default.
Before you start

Before making structural changes, check your current database size and make a backup copy of your .accdb or .mdb file.

Solution 1Recommended

Change the Picture Property Storage Format

Modify your database application options to preserve the original image format instead of converting it to a larger bitmap file.

By default, Access converts images to bitmaps for compatibility, which dramatically increases the file size. Changing this setting will keep embedded JPEGs and PNGs in their native, compressed formats.

1
Access Database Options

Open your Microsoft Access database, click on the 'File' tab in the top-left corner, and select 'Options' at the bottom of the menu.

2
Navigate to Current Database Settings

In the Access Options dialog box, click on 'Current Database' in the left-hand navigation pane.

3
Change Picture Property Storage Format

Scroll down to the 'Application Options' section. Find the 'Picture Property Storage Format' setting and change it from 'Convert all picture data to bitmaps (compatible with Access 2003 and earlier)' to 'Preserve source image format (smaller file size)'.

4
Reinsert Existing Images

Click 'OK' to save the changes. To shrink the size from previously added images, you must delete the old images from your forms or reports and reinsert them under the new setting.

Change the Picture Property Storage Format
Applying Changes: This setting only affects images inserted after the change is made. It will not retroactively compress images already stored as bitmaps.
Free Microsoft Office alternative

Looking for a Lightweight Office Suite? Try WPS Office

While Microsoft Access is a specialized tool for database management, large and unoptimized Office files can slow down your daily workflow. For your essential document, spreadsheet, and presentation tasks, WPS Office is a free, lightweight, and incredibly fast alternative. It features excellent format compatibility with Microsoft Office, a familiar UI, and helps you keep your files optimized for seamless migration.

  1. 1. Download WPS Office: Visit the official WPS Office website and download the free, lightweight installer for your operating system.
  2. 2. Install and Launch: Follow the straightforward installation prompts. The suite installs in seconds and requires minimal system resources.
  3. 3. Open Your Existing Files: Simply double-click or drag and drop your Microsoft Office files directly into WPS to continue editing without losing formatting.
Highly compatible with Microsoft Word, Excel, and PowerPoint formatsLightweight installation saves disk space and runs smoothly on older hardwareBuilt-in PDF tools for easy viewing, editing, and conversionFamiliar user interface requires no learning curve for seamless migrationFree to download and use for all your essential productivity needs
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access database file size grow so fast when adding images?

By default, older versions and standard configurations of Access convert embedded image data into uncompressed bitmap formats to ensure backwards compatibility. This process inflates the file size immensely, even if the image you uploaded was a small, compressed JPEG or PNG.

What is the maximum file size limit for an Access database?

A Microsoft Access database (.accdb or .mdb) has a strict maximum file size limit of 2 GB, minus the space needed for system objects. If embedding images causes your file to reach this limit, you will encounter errors and be unable to add more data until you reduce the file size or link images externally.

Will changing the picture storage format automatically shrink my current database?

No, toggling the 'Preserve source image format' option only applies to new images inserted after the setting is changed. To shrink your database, you must manually delete the existing bitmap-converted images, ensure the new setting is active, and then reinsert your original images. After doing so, perform a 'Compact and Repair' on the database.