Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 1 down vote favorite

I am looking to improve the efficiency of an Access 2010 database by using a web server with images and only storing the hyperlink source in the table, i.e.

http://www.images.com/images/image1.jpg

I know that one can save images as "attachements", using a "blob" object type, but when you're dealing with thousands of images, queries are bogged down, and performance suffers.

In short, is there a relatively simple way of displaying images on Access forms with a source that is a hyperlink address (storing files locally and using filepaths is not preferable)?

share|improve this question

2 Answers

up vote 0 down vote accepted

Access displays web data only via the web browser control. You could place a web browser control on your form and use the Navigate method of the web browser control to display the image from the website.

It is not that big a deal to display locally stored images (i.e., not with a hyperlink). You might find Stephen Lebans' ImageClass demo useful. I've used much earlier versions of it (I just checked and one of my apps uses version 5!), so I can guarantee that his approach works and is easy to use.

share|improve this answer
I'll go with the web-browser control... thanks. – Yaaqov Mar 14 '10 at 21:44
Keep in mind that the web browser control is subject to incompatibilities depending on your version of Internet Explorer, something that is not the case with the ImageClass code. If the images are accessible via SMB networking, I'd say that the ImageClass approach is going to be much more portable from machine to machine because it's not dependent on an outside control that is frequently altered by Windows Update. – David W. Fenton Mar 15 '10 at 21:58
Good points - I'll see how performance turns out. – Yaaqov Mar 16 '10 at 1:42
up vote 1 down vote

This is from Access 2007 and it worked for me. Extract the text from the hyperlink in the query to use on the report:

HyperlinkPart([Picture_2],5)

http://answers.microsoft.com/en-us/office/forum/office_2007-access/how-to-display-a-hyperlink-to-an-image-as-a/90821989-0e86-4aae-9b3a-37cab82634ce:

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.