0

I have an MS sql server database. There is a table with one of the column of the "image" type. Now, the customer wants to read the data from an MS access. He wants to display the images in a form. I have never used access and have no idea of how to do simple things there. Any help will be greatly appreciate.

Thanks, Ramjee

Improve this question
1
  • The first thing to check is to see if Access will treat the image column the same way it treats its own OLE fields. That is, it's remotely possible to bind an image control on an Access form directly to the field. It probably won't work, but try before you start coding! Commented Nov 21, 2008 at 4:57

3 Answers 3

Reset to default
2

Rather than write out the stored images to files in order to display them, it may be possible to use ASP to display the image and a web browser control on the Access form to display the page. I have not tried this.

How To Display Images Stored in a BLOB Field: http://support.microsoft.com/kb/173308

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

You can put regular Image control on form and state MyPic.PictureData=PicField in Current event.

Or you can use AccessImagine, which is great for pictures in MS Access and requires no scripting. You can download it here - http://access.bukrek.net/download

Improve this answer

Comments

0

I think you can do this by using streams. Stream the image from the field to an unbound image control. We use the same process for opening documents and other binary data stored in an SQL Server database.

On the other hand, Access had an Image control that can be linked to a field in a table. That should be a lot easier to user!

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.