Skip to main content
Windward

Displaying Images Stored in Access and OLE Databases

Overview

OLE DB, which is used to provide connection to Access Databases, adds a header to attachments which makes bitmaps show as invalid bitmap files. Additionally, Access actually stores attachments in a subtable which is not made available to the metadata.

Resolution

There are two steps. First, set the check.for.ole.images flag to "true" (added in version 12.5.28.0).

  • For AutoTag, it's easiest to set this in the registry.
    • Open the registry editor.
    • Create the key (not value, but key) HKEY_CURRENT_USER\Software\Windward Studios\Reporting Engine

    • In the Reporting Engine key create a string value check.for.ole.images

    • Set the value of that to true

       

​​regedit.PNG

  • ​For the .NET Engine, you can set the value in the app.config file

  • For the Java Engine, you can set this in the windwardreports.properties files

 

The second step is to manually edit your select to get the actual file data from the hidden tables. Instead of

select [tableName].[myAttachment] from [tableName]

You'll need to reference the attachment subtable, like so:

select [tableName].[myAttachment].Attachments.FileData from [tableName]

 

The three fields available are FileData, FileName, and FileType - you can filter on those as well, using a WHERE clause.

  • Was this article helpful?