HOW TO: Display Access 2000 Hyperlinks in a FrontPage 2000 Web

When you open a FrontPage-created Active Server Page (ASP) that displays results from a Microsoft Access 2000 database with hyperlinks in the browser, the hyperlinks may be displayed as text or in the following manner: This article shows you how to resolve this issue.

Display Access 2000 Hyperlinks in a Web

To resolve the hyperlinks issue, follow these steps:

1. Use the drag-and-drop method to insert the Access 2000 database into FrontPage.
2. In the Add Database Connection dialog box, type a name for your new connection, and then click Yes.
3. When prompted with the following message:
   It is recommended that you store your files in the "fpdb" folder. Do you want to import the database files to this folder?
   click Yes.
4. On the Insert menu, point to Database, and then click Results.
5. Proceed through the Database Results Wizard, selecting the appropriate settings for your database, and then click Finish.
6. On the ASP page that holds your database, select to highlight the field that contains your links.
7. Right-click the field and click Hyperlink on the menu that appears.
8. In the Edit Hyperlink dialog box, delete http:// in the URL text box.
9. Click Parameters.
10. In the Parameters dialog box, click Insert Field Value, and then click the database field name that includes the hyperlink.
11. Click OK.
12. In the Edit Hyperlink dialog box, click OK.
13. On the File menu, click Save.