Access ADP display SQL image stored as varbinary(MAX)

I have an access ADP project with SQL 2012 back end.

I want to display images in sql. Hopefully by populating a list with a users images, and the the user being able to select the image they want to see and it somehow being displayed?

I cant seem to find much on the net about doing this with ADP.
LVL 6
CaptainGibletsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BitsqueezerCommented:
Hi,

I hope you know that ADPs are aimed to work up to the last known SQL Server version which was out when the Access version was released? Means: A2007 => SQL Server 2005, A2010 => SQL Server 2008, A2013: No longer available.
So any SQL Server greater than 2008 is not directly supported by ADPs, it CAN work but on your own risk.

I want to display images in sql
If you want to get answers which fits your needs it is useful to ask the right questions...:-)
You can of course not display images in a result set coming from a SQL command. That's the job of the frontend, in your case of ADP. So I guess your real question is "how to display images in an ADP form".

As far as I know there is no direct possibility to use the binary data from a varbinary(MAX) column. Access uses the image datatype of former SQL Server versions to directly display images, but this datatype is of course deprecated.
The best method is to save the images at a user-reachable path as files and only save path and filename in the database. Makes the performance of the table a lot better and Access can (beginning with A2007) use a column name of the table with the path to display the image found on this path and file name.
If you want to stay with varbinary(MAX) you could download the binary data to a local user's temp folder and set the column source of the image in the form to this temp folder. It's a good idea to double save the image in this case so in a list of images you have only thumbnails which are saved as smaller image on the server in a separate varbinary(MAX) column, this allows you to download this thumbnail images a lot faster so you only need to download the full image in the case where the user really selects it.

Cheers,

Christian
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.