Display Uploaded file from MS Access using ASP

[hotflash]

Hi All,

I uploaded the Title (text), Description (text) and SourceFileName (OLE Object) into the MS Access OK however, how can i display the file for example MS word so user can view it from the website? Below is part of the ASP code that I used, the Title and Description text showed up OK but I would like to have sometype of hyperlink or something for the SourceFileName so user can view it from the website. Thanks for your help.

Response.Write("<TD>" & RS("Title") & "&nbsp;</TD>")
Response.Write("<TD>" & RS("Description") & "&nbsp;</TD>")
Response.Write("<TD><A HREF="& RS("SourceFileName") &">View</A></TD>")

[CroCrew]

Is the stored value RS("SourceFileName") the relative path to the word document or just the name of the document?

[hotflash]

Hi CroCrew,

Name of the document defined in MS Access as OLE Object. Hope this helps.

Please help. Thanks.

[CroCrew]

This should point you in the right direction.

http://support.microsoft.com/kb/175261

[hotflash]

Hi CroCrew,

Thanks for your BEST recommendations. I got it work now however, when I clicked on the "View" to view the file, the file will open OK. How can I get it to open using a new window? I have added the onclick=window.open but does not help.

Below is the statement that I am currently used.

Response.Write("<TD><A HREF="& RS("DestFileName") &">View</A></TD>")

Can't get the statement below working.

Response.Write("<TD><A onclick="window.open('HREF="& RS("DestFileName") &"')">View</A></TD>")

Thanks once again for your support.

[hotflash]

Please ignore this message. I got it work fine now. Thanks once again.