Microsoft KB Archive/101089

{|
 * width="100%"|

ACC1x: Do Not Have Permissions to Modify Secured Report

 * }

Q101089

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SYMPTOMS
When you are trying to print a secured report, you receive the error message "You don't have permissions to modify ."

CAUSE
This problem will occur if a person other than the application's creator attempts to preview the secured report using a different default printer than the default printer that was in use when the application was created.

RESOLUTION
Create the following macro and add it to OnClose property of the report:

  Macro Name      Action    Argument --  Secured Report  SendKeys  {ESC}

STATUS
This behavior no longer occurs in Microsoft Access version 2.0.

Steps to Reproduce Behavior
NOTE: To reproduce this error you need to have a database with security already implemented.

 Log into Microsoft Access as any user other than Admin. Create a new database. Import the Employees table from the sample database NWIND.MDB. Use the ReportWizard to create a new report based on this table. Save the report as Report1.  Create an AUTOEXEC macro with the following actions/arguments:

      Action      Argument   View OpenReport Report1    Print Preview  Assign execute permissions to the report for all groups and users. Quit Microsoft Access.</li> In the Microsoft Windows Control Panel, select a different printer for your default printer than what is currently selected.</li> Start Microsoft Access, and then log in as a different user than the one who created the report.</li> Open the database created in step 2. The report will open in preview mode.</li> Close the report. Note that the error occurs.</li></ol>

Keywords : kbusage

Issue type : kbprb

Technology :