ACC97: Hyperlink Can't Open Object and Web Toolbar Disappeared

ID: Q191081

The information in this article applies to:

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When using the FollowHyperLink method to open a secured form or report within a second Microsoft Access 97 database, you may receive the following error message:

You don't have permission to run '<form name>'

After clicking OK on the error message, you find that the Web toolbar is not displayed, and you are unable to go back to the calling object.


CAUSE

The form referenced within the hyperlink is secured, and the currently logged on user does not have Open/Run permissions set for that form.


RESOLUTION

When you use the FollowHyperLink method to open a secured form or report within an external Microsoft Access database, you must first ensure that you have Open/Run permissions set for that form.


STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97.


MORE INFORMATION

CAUTION: Following the steps in this example will modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and perform these steps on a copy of the database.

Steps to Reproduce Problem


  1. Start Microsoft Access and open the sample database Northwind.mdb.


  2. On the Tools menu, click Security, and then click User And Group Permissions.


  3. In the User And Group Permissions dialog box, under Permissions, clear all permissions for the Admin user and Users Group. Under Object Name, select Customers form, and under Object Type, select Form.


  4. Close the Northwind database


  5. Create a new database called TestLink.mdb.


  6. Create a new module and type the following procedure: 
    
      Sub TestLink()

         Application.FollowHyperlink "c:\Program files\Microsoft _
           Office\Samples\Northwind.MDB","Form Customers",True

      End Sub


  7. To test this function, type the following line in the Debug window, and then press ENTER.
    TestClass


Microsoft Access will try to open the Customers form, but will return the error message mentioned in the "Symptoms" section. When you click OK to close the error message, you will be unable to move back to the calling object. 


Keywords          : kberrmsg kbdta PgmErr IntLink 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: April 29, 1999