ADP and SQL Image Field

[Guest]

Hello:

I have an employee database that has a field named Picture. The application
is an Access Data Project that is bound to a SQK Svr 2000 database. The
datatype for the picture field i s Image.

Whhen I paste a picture into the field, the display I get is the filename
and extension: For example

picture.jpg

I can open the picture by double clicking on it. I want the picture to
display automatically when the record is loaded. How can I do this.

Thanks
Brennan

 

[Sylvain Lafontaine]

The type field « Image » on SQL-Server is a misnomer and should have been
called Binary or LongBinary or something like that instead of Image: it can
be used for storing any kind of binary data - including images. However,
Access - with either MDB or ADP files - has a peculiar way of storing images
in a database: instead of directly storing their binary content, it stores
their names only or it transforms them to OLE objects before storing them
into in OLE field (for MDB) or an Image field (for SQL-Server).

You should look into the Access newsgroup for answers about using and
storing images with Access; the solutions are the same for both MDB files
and ADP projects.

 

[Sylvain Lafontaine]

The last time I stored images in a ADP project, I used a Bound Object Frame,
opened the image in MS-Paint, copied it to the clipboard and then pasted
into the bound object. However, if I tried to copying and pasting the image
directly into the bound object frame without using the clipboard, this
didn't worked; ie. only the name of the image was visible and I had to
double-clicking it to see it.

The way Access stores and manipulates images with its standard controls is
simply nut and it's capabable of driving anyone crazy. An easier solution
would be to use a commercial control like DBPix.