1

Created an .accdb database using Access 2016 32 bit.

It contains a report with an Image object like a letterhead.

I use a macro to export this report to a PDF when the user clicks on a button.

This works fine on my machine.

I save the database as an .accde file or as .accdr to distribute to a user.

The user is running Access Runtime 2016 under Windows 7.

When the user opens the .accdr database it runs slowly but works.

When the user opens the .accde file it runs quicker,

BUT,

the PDF that is created contains all the report information except the Image block which is blank.

The Image is visible on the report which is about to be exported.

I have tried using a .jpg and a .bmp for the Image but it makes no difference.

2 Spice ups
2

Is the picture embedded or linked? I seem to recall having issues at one time if an image was too large (dimensions on the report), have you tried making it smaller as a test?

3

Check the Options → Current Database → Picture Property Storage format

There are two options: Either Preserve source image format (smaller file size) Or convert all your picture data to bitmaps (compatible with Access 2003 and earlier)

If the image is added when the second option is been selected then the non-BMP graphics do not appear in the Access 2016 version.

Source: How To Fix Access Forms And Reports Not Showing Image Issue

4

Thanks for all your response.

We found the problem. The download of Runtime 2016 has a problem in which has been corrected in Microsoft updates. However, we are running on a machine which is blocked for Internet access so the fixes were not applied. It works fine on other machines.

The next problem is how to run the fixes without the Internet connection. .

To answer you other kind suggestions:

The image was embedded but linking it did not help.

Picture property storage format: Was always " Preserve source image format" option. With the other option the image disappeared off both the Report and the PDF.

Thanks again for coming back to me.

5

Exploring a further solution. The German website WSUS offers downloads of Microsoft updates for Windows and Office that can be downloaded onto a file server, a hard drive or a flash drive etc. These updates can then be run on a computer which does not have an Internet connection. I am hoping that I will be able to repair the client’s Access Runtime on their Win7 this way and get past the problem. Watch this space…

6

Have you checked the Microsoft Update Catalog site? https://www.catalog.update.microsoft.com/Search.aspx?q=Office%202016

7

What update did it wind up being? I am having the same issue with a report to PDF that is one big image.

Jeff