Microsoft KB Archive/240890

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

Article ID: 240890

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q240890



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 ' '

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

Additional query words: prb

Keywords: kbprb KB240890

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.