Reading the Image from a SQL DB and displaying in a Access 2000 ADP project

[MORPHEUS]

Hi, i need a way to display a Image witch are stored in a SQL2000/Image
field on the Access 2000 ADP frontend.

Has anyone a good tutorial or help for me how to do that ?

I have see in in the northwhind sample db, but this wont work on the sql
because its an ole field...


Thanks in advance for any feedback

Volkan S.

 

[Exponent]

Assuming that the images are stored as raw binary i.e. not OLE Embedded) here are two possible approaches:

1) Extract the binary data to a temporary file, then load that file into an Access Image Control. Note
that you may need to install the relevant office graphics filters on any machine that will display the
images. You may also need workarounds to suppress the progress dialog and to prevent the 'scroll too quick'
crash. This requires a fair amount of code, but you can find samples and code here: http://members.tripod.com/accdevel/
And here: http://www.mvps.org/access/toc.htm

2) Alternatively you can use a 3rd party control designed to work directly with the field data. Our DBPix
control is one example - it binds directly to long binary fields requiring little or no code and adds useful
functionality, such as EXIF info support, lossless jpeg rotation, Zoom & Pan, built-in file browsing, TWAIN/scanner
integration, asynchronous decoding and more. For more info, downloads, samples etc, see the url below.