Picture Hotspot Link to Access DB

External Since: Sep 29, 2008 Posts: 1

I would like to create a hotspot link on a picture that, when clicked,
queries an Access database. I see the parameters option in the "edit
hyperlink" dialoge box, but I don't know how to write the string in the
name/value menu. Any suggestions would be much appreciated.

External Since: Oct 11, 2003 Posts: 12573

In your page write before the image your SQL code to open the DB and get your URL from the DB as say
<%
' SQL DB code here for the link recordset objRS ..
hotlink=objRS("linkfieldname")
%>

Then create your hot spot link to anything existing page
- and in code view edit the links in the area tag to be say:
<area href="<%=hotlink%>" ...>
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________

"Tim Dyeson" <TimDyeson.DeleteThis@discussions.microsoft.com> wrote in message news:F92B6890-6708-4EE3-B25A-9706219380BC@microsoft.com...
|I would like to create a hotspot link on a picture that, when clicked,
| queries an Access database. I see the parameters option in the "edit
| hyperlink" dialoge box, but I don't know how to write the string in the
| name/value menu. Any suggestions would be much appreciated.