Make dynamic data from an Access DB have hyperlinks

[kiwieur]

Hi,
Not sure if I am going to be able to explain this properly but here goes.

I have an access DB table that stores the location of files on the web server.

The idea is that if a new file is uploaded then the user can enter the file path and it will show as an hyperlink that other users can click to open the file.

I have a insert record form where the users will enter the data.

Then i have a asp page that pulls data from the table using a recordset

This is the data that I want to hyperlink

<td><a href=><%=(rsFiles.Fields.Item("Location").Value)%></a></td>

I can get it to display as a link but get the following error message

You are not authorized to view this page 
You might not have permission to view this directory or page using the credentials you supplied. 

--------------------------------------------------------------------------------

If you believe you should be able to view this directory or page, please try to contact the Web site by using any e-mail address or phone number that may be listed on the kiwinetuk home page.

You can click  Search to look for information on the Internet.




HTTP Error 403 - Forbidden 
Internet Explorer

Does anyone have any ideas why this would happen, any help would be appreciated

Regards

Paul

 

[kiwieur]

Ok, I have managed to sort it changed the following from this

<td><a href=><%=(rsFiles.Fields.Item("Location").Value)%></a></td>

to this

<td><A HREF="<%=(rsFiles.Fields.Item("NameOf File").Value)%>" target="_blank"><%=(rsFiles.Fields.Item("NameOf File").Value)%></A></td>

Regards

Paul