[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 492
  • Last Modified:

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.
0
rawilken
Asked:
rawilken
  • 3
  • 2
1 Solution
 
HainKurtSr. System AnalystCommented:
put regular Image control on form and state MyPic.PictureData=PicField in Current event.
0
 
HainKurtSr. System AnalystCommented:
maybe you can try this control: http://access.bukrek.net/
0
 
rawilkenAuthor 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.
0
 
HainKurtSr. System AnalystCommented:
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...
0
 
rawilkenAuthor Commented:
I finally go the AccessImage control to work!
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now