Displaying images on acces report from a VPF (.DBF) database

  • Thread starter Thread starter Héctor Balanzar
  • Start date Start date
H

Héctor Balanzar

Hello there:

I have a 3rd party database and it's tables are in Visual Fox Pro (.dbf).
One of the tables contains an image record. I need to make a report that
shows the stored images since the application does not support such a
report. I can make regular queries to the database trough VFP ODBC driver
(6.x) everything but the images is correctly displayed within the report.

I've used a Bound Object Frame Control to display the field, but nothing
happens. I'm not a regular user for ms-access, so I'm unaware if access is
able to handle such records within it's reports. Any hint will be helpful,
thanks in advance.

Best regards
Hector Balanzar
 
Hector:

It depends on how the image was stored in VFP. if its stored as an OLE
object then a bound object frame (or more likely an Image control) might be
approrpropriate. If it was stored as simply binary data (a blob), then
there's no OLE header and the image must be written out to disc first as a
file from the record (see the knowledge base on GetChunck method) and then
using an Image control, set the picture property to the file string.
 
Back
Top