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

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).

Symptoms
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.
Cause
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.
Resolution
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.
More information

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.
prb
Properties

Article ID: 240890 - Last Review: 01/06/2015 04:59:43 - Revision: 2.0

  • Microsoft Access 2000 Standard Edition
  • kbnosurvey kbarchive kbprb KB240890
Feedback