Show All

Hide All

When you create a hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) in a Microsoft Access file (Microsoft Access file: An Access database or Access project file. An Access database stores database objects and data in an .mdb file. A project file doesn't contain data and is used to connect to a Microsoft SQL Server database.), you can make the path to the destination (destination: General term for the name of the element you go to from a hyperlink.) of the hyperlink a fixed location (absolute link), which identifies the destination by its full address— such as C:\My Documents\Sales.doc— or you can make the path a relative link (relative link: When a hyperlink uses a path based on a relative link, you can move the file that contains the hyperlink and the hyperlink destination without breaking the hyperlink. Move the file that contains the hyperlink and its destination together.). You can easily change the path of a relative link by setting the hyperlink base (hyperlink base: When a relative link is based on a path you specify (the first part of the path that is shared by the file containing the hyperlink and the destination file), that path is the hyperlink base.) for the Access file. The value of the HyperlinkBase property of an Access file can be a URL (Uniform Resource Locator (URL): An address that specifies a protocol (such as HTTP or FTP) and a location of an object, document, World Wide Web page, or other destination on the Internet or an intranet, for example: http://www.microsoft.com/.) or a location on a network or your hard drive.

For example, you may want hyperlinks to Web pages on an intranet (intranet: A network within an organization that uses Internet technologies (such as the HTTP or FTP protocol). By using hyperlinks, you can explore objects, documents, pages, and other destinations on the intranet.) server in your Access file. If you set the value of the hyperlink base to http://servername1, you can create a hyperlink as a relative link, such as webpage.htm. Clicking this hyperlink opens the web page located at http://servername1/webpage.htm. If you then move the web pages to a different intranet server, you only need to change the value of the HyperlinkBase property to http://servername2 to adjust all of the relative links in the Access file.