Solved

SQL Server Image Field

Posted on 2012-03-09
5
484 Views
Last Modified: 2012-03-09
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
Comment
Question by:rawilken
  • 3
  • 2
5 Comments
 
LVL 51

Expert Comment

by:HainKurt
ID: 37702696
put regular Image control on form and state MyPic.PictureData=PicField in Current event.
0
 
LVL 51

Accepted Solution

by:
HainKurt earned 450 total points
ID: 37702707
maybe you can try this control: http://access.bukrek.net/
0
 

Author Comment

by:rawilken
ID: 37702878
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
 
LVL 51

Expert Comment

by:HainKurt
ID: 37702969
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
 

Author Comment

by:rawilken
ID: 37703101
I finally go the AccessImage control to work!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question