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 <report name>."
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.
MORE INFORMATION
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.
- In the Microsoft Windows Control Panel, select a different printer for your default printer than what is currently selected.
- Start Microsoft Access, and then log in as a different user than the one who created the report.
- Open the database created in step 2. The report will open in preview mode.
- Close the report. Note that the error occurs.
Keywords : kbusage
Issue type : kbprb
Technology :
Last Reviewed: November 4, 2000 |