ACC2000: "The ADP File Is Not in the Correct Format..." Error When You Try to Insert a Bookmark

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: When you click OK, you receive the following error message: If you try to add a bookmark to a hyperlinked graphic file, you may receive the following error message 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:

1. Open the sample database Northwind.mdb.
2. Open the Suppliers table in Datasheet view.
3. Select a blank field in the Home Page column.
4. On the Insert menu, click Hyperlink.
5. In the Insert Hyperlink dialog box, click File.
6. Select a Word document that contains at least one bookmark, and then click OK.
7. 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.
8. Click OK.

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

1. Complete Steps 1 through 6 of the "Resolution" section of this article.
2. Click Bookmark.
   
   Note that you receive the error messages described in the "Symptoms" section of this article.