Microsoft KB Archive/191081

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

Article ID: 191081

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q191081



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



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

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
 Start Microsoft Access and open the sample database Northwind.mdb. On the Tools menu, click Security, and then click User And Group Permissions. 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. Close the Northwind database Create a new database called TestLink.mdb.</li>  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 </li> To test this function, type the following line in the Debug window, and then press ENTER.

TestClass

</li></ol>

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.

Additional query words: URL URLs you don t have permission to run can t

Keywords: kbbug kberrmsg kbpending KB191081

-

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

© Microsoft Corporation. All rights reserved.