Photograph that is web hosted in a report.

[RogueVW]

We have moved an Access DB to a MYSQL DB that is web hosted and use a Ruby interface.

Creating elegant reports in Ruby is difficult and time consuming, so until then I have a front end Access DB linked to the hosted MYSQL back end for many of the reports.

I am having problems with creating reports with photos that are hosted on the web server. The method used and well documented on Tek-tips does not seem to work for hosted jpgs.

Description of the report would be an info page for each student with a photo of the included. The photos were stored locally but are now hosted on the webserver.

Currently:

Private Sub Group_Format(Cancel As Integer, FormatCount As Integer)
On Error GoTo NoPhoto_Err
Me![Photograph].Properties("Picture") = "c:\data\pictures\" + Me![LastName] + "_" + Me![FirstName] + Me![contactID]+".jpg"
Exit Sub

NoPhoto_Err:
If Err.Number = 2220 Then
Me![Photograph].Properties("Picture") = "c:\data\pictures\NoPhoto.jpg"
Else
MsgBox Err.Description
End If
End Sub

I would like to refer to the photo stored on the web such as:
Me![Photograph].Properties("Picture") = "

http://www.odysseyexpeditions.com/"

+ Me![LastName] + "_" + Me![FirstName] + Me![contactID]+".jpg"

This does not work.

Any ideas? Does Access even allow this?