hi, i've been create an upload form to uplad file.
i'm using ASP and MS Access. when i upload file, database just only record the path.
I want the file i've upload may open based on it extension--for my case I'm using ms word-- when I click the path.

anyone can help me, please.

I need this script programming.

Say you are getting the path of the uploaded file into the variable fname. You can write the following to display a hyperlink for the user to download the file.
<%
  Response.write "<a href=" & fname & ">Click to Open</a>"
%>


Regards
Raj

g, thanks for comment.
I've try your suggest, but it doesn't work.

this is for detail.
I'm using ASP script to stored file in database which is MS Access.
Ms Access stored file formed as path. just only path. for example D:\weedee\Doc1.doc
when I open browser e.g IE. it shows the records that I stored in database for example D:\weedee\Doc1.doc

how do I write the script to open this records according to it extension when i clicked it on?

WeeDee,

Where do you upload the files to? How do you store the path in the DB?

You should not use absolute reference(viz "D:\weedee\doc1.doc") for storing path in db. Use relative reference (viz "weedee/doc1.doc") to get that to work. Also remember, you upload the files to some folder under your website. Say your website is hosted under "D:\wwwroot\weedee\", then, you may upload the folders to some where within "D:\wwwroot\weedee\Documents" and the path in the DB should show something like "/documents/doc1.doc", which should be fetched from the db and shown as href part for the link.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

well, I think it was a lil'bit mistakes. I forgot to say that I'm using ASPSimpleUpload. the vFolder created as "uploads/" under c:\wwwroot\inetpub\ta_asp5 . it was success to store file in that folder but I can't see the record in my database. I'm using the script below :

<%
set conn = server.createobject("ADODB.connection")
    conn.open "dee", "",""

sqlrekord = "select dok from tablestoring"

set rekord = server.createobject("ADODB.Recordset")
    rekord.open conn,sqlrekord
%>

it will save a file into field dok, but when I combine with ASPSimpleUpload script the file cannot saved into field dok.

it sound dumb, but I really really confuse. can you tell me how the steps to save file in "uploads/" folder and field dok at the same time. and then get the file when it clicked as shown in a browser

I haven't used "ASPSimpleUpload" yet, so I cannot comment on that. May be you can refer to the site from where you downloaded that for details on the same in integration into your code.

Cheers!

_________________________
- Vijay G
Strive for Perfection