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.


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)?

2 Answers 2


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.

  • 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. Mar 15, 2010 at 21:58
  • Good points - I'll see how performance turns out.
    – Yaaqov
    Mar 16, 2010 at 1:42

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



You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .