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

• Microsoft Access 97

SYMPTOMS

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

When you use 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>'

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

Additional query words: URL URLs

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