> I have a field in an Access database that stores a URL to a file on in a 

> sub-directory. When I retrieve the fields using ADO, the URL's in the 

URL 

> field are not live. I cannot click on them to run the associated file. I 

> need to be able to retrieve the URL stored in the database, have it show 

> up on the webpage, and have it run the associated file when clicked on. 

I 

> don't not want a hard coded link in the webpage. The whole purpose is to 

> be able to add or remove files from the database, have it automatically 

> show up in the web page, and be able to run the file when I click on the 

> link.  



Hi,

I just had the same problem myself. I am using PWS on win 98, so if you 

are using IIS things might be a bit different. What you must do is make 

sure the path to the files on your drive has had a correct virtual path 

mapped to it. On PWS, click Advanced, then add a virtual directory to use 

in the URLs from the database. Click on one of the existing Virtual 

Directories and tehn click Edit Properties to see where it maps to.

Hope this helps.

Maybe you can solve my question that I posted, you might come across the 

same issue your self...



Michael Mckenzie

Michael,



When u retrieve thr URL using ADO place it between the anchors



 



<a href=<%=rs("myLink")%>> <%=rs("myLink")%></a>



Hope this helps(and works)



Milan Shetty

From: "Michael Mckenzie"

Reply-To: "asp_discuss"

To: "asp_discuss"

Subject: [asp_discuss] Re: Retrieve URL stored in Access Database

Date: Mon, 25 Jun 2001 06:03:57

> I have a field in an Access database that stores a URL to a file on in a

> sub-directory. When I retrieve the fields using ADO, the URL's in the

URL

> field are not live. I cannot click on them to run the associated file. I

> need to be able to retrieve the URL stored in the database, have it show

> up on the webpage, and have it run the associated file when clicked on.

I

> don't not want a hard coded link in the webpage. The whole purpose is to

> be able to add or remove files from the database, have it automatically

> show up in the web page, and be able to run the file when I click on the

> link.

Hi,

I just had the same problem myself. I am using PWS on win 98, so if you

are using IIS things might be a bit different. What you must do is make

sure the path to the files on your drive has had a correct virtual path

mapped to it. On PWS, click Advanced, then add a virtual directory to use

in the URLs from the database. Click on one of the existing Virtual

Directories and tehn click Edit Properties to see where it maps to.

Hope this helps.

Maybe you can solve my question that I posted, you might come across the

same issue your self...

Michael Mckenzie