I have a link table in an access database and using a query I want to call the links of an employee into a web page. The link_name field is text and the link_url field in a hyperlink in the database.
I need to be able to call the recordset and click on the links which would direct me to another web page. Currently clicking the link puts the url in the current browser url:
<table border="1" width="100%">
sql = "SELECT tblLink.link_name, tblLink.link_url FROM tblEmployee INNER JOIN tblLink ON tblEmployee.User_id = tblLink.user_id"
do until rs.eof
Please can somebody help me solve this problem?