Solved

SQL Server Image Field

Posted on 2012-03-09
5
479 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
Comment Utility
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
Comment Utility
maybe you can try this control: http://access.bukrek.net/
0
 

Author Comment

by:rawilken
Comment Utility
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
Comment Utility
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
Comment Utility
I finally go the AccessImage control to work!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
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…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now