Article ID: 320713 - View products that this article applies to.
This article was previously published under Q320713
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
When Microsoft Access attempts open a report, it will automatically switch to Design view if an existing Print Preview view of the same report is not first closed. The report will switch views both in MDB and MDE files.
Currently, there are only two known ways to work around this problem:
Method One: Use Code to Check the Status of the ReportYou can use the AllReports collection to check the status of the report. If the report is currently open in Print Preview view, you can issue a command to close the report and then issue a command to open it for printing. To see an example of how to do this, follow these steps:
Method Two: Use Access Security to Remove the Read Design PermissionUsers who cannot access Design view will not see this problem. Therefore, you can prevent this problem by using Microsoft Access security to remove a user's Read Design permission. This will restrict a user's access to Design view.
For additional information about how to secure a database in Microsoft Access, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/289885/ )Description of how to help protect a Microsoft Access database
(http://support.microsoft.com/kb/305542/EN-US/ )ACC2002: Understanding the Role of Workgroup Information Files in Access Security
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce the Behavior
For more information about the AllReports collection, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type AllReports in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For more information about Access security, click Microsoft Access Help on the Help menu, type Secure an Access database and its objects with user-level security in the Office Assistant or the Answer Wizard, and then click Search to view the topic.