I want to acces a database directly from a link.<BR>I only want to acces one record but i can&#039t find out how<BR>i have this so far<BR>&#060;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"&#062;<BR><BR>&#060;html&#062;<BR>&#060;TITLE&# 062;db1parm.asp&#060;/TITLE&#062;<BR>&#060;body bgcolor="#FFFFFF"&#062;<BR>&#060;% <BR>&#039 My ASP program that talks to a database<BR>set conntemp=server.createobject("adodb.connection")<B R>conntemp.open "DSN=pagter"<BR>p1=request.querystring("ID")<BR>te mp="SELECT * FROM authors where AU_ID=" & p1<BR>set rsTEMP=conntemp.Execute ("temp")<BR>&#039Set rs = conn.Execute("SELECT * FROM pubs") <BR>howmanyfields=rsTEMP.fields.count -1<BR>%&#062;<BR>&#060;table border=1&#062;<BR>&#060;tr&#062;<BR>&#060;% &#039Put Headings On The Table of Field Names<BR>for i=0 to howmanyfields %&#062;<BR> &#060;td&#062;&#060;b&#062;&#060;%=rsTEMP(i).na me %&#062;&#060;/B&#062;&#060;/TD&#062;<BR>&#060;% next %&#062;<BR>&#060;/tr&#062;<BR>&#060;% &#039 Now lets grab all the records<BR>do while not rsTEMP.eof %&#062;<BR>&#060;tr&#062;<BR>&#060;% for i = 0 to howmanyfields%&#062;<BR> &#060;td valign=top&#062;&#060;% = rsTEMP(i) %&#062;&#060;/td&#062;<BR>&#060;% next %&#062;<BR>&#060;/tr&#062;<BR>&#060;% rsTEMP.movenext<BR>loop<BR>rsTEMP.close<BR>set rsTEMP=nothing<BR>conntemp.close<BR>set conntemp=nothing%&#062;<BR>&#060;/table&#062;<BR>&#060;/body&#062;<BR>&#060;/html&#062;<BR><BR><BR><BR>the link i use to actevate this program is<BR>&#060;A href="name.asp?ID=1" target="_blank"&#062;haal ID op&#060;/font&#062;