I am writing my ASP by hand rather than using ASP.NET as that is not available to me.

I have a database in that MS-Access database is a table called links

In that table there are 4 columns:
The First is a autonumber field to act as an ID this is the Primary Key
The Second is the URL
The Thrid is the Site name
The Forth is the Information about the site

What I want to do is display the Site Name and have that text linked upto to URL and below display the Info about the site.

I have used Response.Write and can simply display the information but I can't get the Text and the URL to work together.

Can anyone help?