Can I use DBPix with existing OLE Object images in my Access Database ?
|The OLE-Object field-type supports several methods of storing images. DBPix can read existing images in OLE-Object fields if they are stored as raw binary data.|
Images can also be stored in OLE-Object fields using OLE Linking or OLE Embedding. This format is specific to Access and creates additional header information which is stored in the field. Since this format is not officially documented it is not possible to reliably read images stored this way.
You can see if an OLE-Object field contains raw binary data by opening the table and looking at the record. If the text reads 'Long Binary Data' then the data is raw binary, otherwise it is probably OLE Linked or Embedded (e.g. if you see something like "Package" or"'MSPaint Object").
If you have existing images stored using OLE Embedding then it may be possible to save the images back to files using the associated automation application, either under scripted or manual control.
If you have external image files you can batch-load them or selectively load image files that matching each record in some way. Look for Technical Articles and Samples illustrating these techniques.