By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,391 Members | 1,387 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,391 IT Pros & Developers. It's quick & easy.

Display Uploaded file from MS Access using ASP

P: 85
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>")
Jan 25 '08 #1
Share this Question
Share on Google+
5 Replies


CroCrew
Expert 100+
P: 563
Is the stored value RS("SourceFileName") the relative path to the word document or just the name of the document?
Jan 25 '08 #2

P: 85
Hi CroCrew,

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

Please help. Thanks.
Jan 25 '08 #3

CroCrew
Expert 100+
P: 563
This should point you in the right direction.

http://support.microsoft.com/kb/175261
Jan 25 '08 #4

P: 85
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.
Jan 26 '08 #5

P: 85
Please ignore this message. I got it work fine now. Thanks once again.
Jan 26 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.