Search code examples
ms-accessjpegms-access-forms

MS Access form size increases when background image added

I have a JPEG file which I would like to use as a background picture of all of the forms in my MS Access Database. The picture size is about 80 kilobytes. However, for every form I add it to, the database size increases by approximately 12 megabytes and does not decrease after Compact and Repair. Why is this happening and what can I do to avoid this?

Solution

  • I think I've found a solution, but not sure if the problem is going to return at some point.

    1. Create an empty Access database and import all objects from the original database.
    2. Remove all background images from all forms in the new database.
    3. Compact and Repair new database. Not sure if this step is required, but I did it.
    4. Add all background images again.

    Simply moving all objects to a new file didn't work, neither did deleting and re-uploading the background images in the old file, so seems like both actions are required.

    If anyone explains why this issue is happening and offers a better solution, I'm happy to accept that as an answer.