This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
When you insert a hyperlink that points to a Microsoft Word document, a Microsoft Excel workbook, a Microsoft Project file, or a Microsoft PowerPoint presentation, and then click Bookmark, you may receive the following error message:
The ADP file is not in the correct format for a Microsoft Access project.
When you click OK, you receive the following error message:
Microsoft Access could not open this file or could not parse a file of this type.
If you try to add a bookmark to a hyperlinked graphic file, you may receive the following error message
Unrecognized database format '<filename>'
followed by the same second error message.
Although you can create a hyperlink to a much wider range of formats, the Bookmark button in the Insert Hyperlink and Edit Hyperlink dialog boxes can only browse for bookmarks in a limited number of file formats, such as HTML and ASP.
The following steps illustrate a method that you can use to add a bookmark to a hyperlink:
Open the sample database Northwind.mdb.
Open the Suppliers table in Datasheet view.
Select a blank field in the Home Page column.
On the Insert menu, click Hyperlink.
In the Insert Hyperlink dialog box, click File.
Select a Word document that contains at least one bookmark, and then click OK.
Append a pound sign (#) followed by the name of the bookmark to the document name that is displayed under Type the file or Web page name.
For example, Bookmark.doc#Chapter1 would open the document Bookmark.doc to the bookmark Chapter1.
NOTE: Individual worksheets in an Excel workbook are considered bookmarks; therefore, you can implement the same syntax for these as well. For example, to open an Excel workbook called WorkBook1.xls at the sheet named Sheet3, you would use WorkBook1.xls#Sheet3.
Steps to Reproduce the Behavior
Complete Steps 1 through 6 of the "Resolution" section of this article.
Note that you receive the error messages described in the "Symptoms" section of this article.