We help IT Professionals succeed at work.

SQL Server Image Field

I have a SQL Server database with a field that is set as image. I know it displays pictures as another application accessing it displays photos from this field (iot is the only image field in the table). I cannot for the life of me get the photos to display in a standard access form.
Comment
Watch Question

HainKurtSr. System Analyst
CERTIFIED EXPERT

Commented:
put regular Image control on form and state MyPic.PictureData=PicField in Current event.
Sr. System Analyst
CERTIFIED EXPERT
Commented:
maybe you can try this control: http://access.bukrek.net/

Author

Commented:
I tried AccessImage. It reports No Image for all the records I have checked! I am pretty sure each record has an image of some sort in it.

I have also created palin image, bound image, un bound image controls and not been successful with any of them.
HainKurtSr. System Analyst
CERTIFIED EXPERT

Commented:
what do you have in image field? can you save it to a file (a small one) and post here... maybe it is an unsupported image...

Author

Commented:
I finally go the AccessImage control to work!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.