Fix Microsoft Access Freezing After Opening a Report in Print Preview
Question details
Restore normal interaction with an Access database after opening a report in Print Preview.
- Product
- Microsoft Access
- Device & OS
- Windows
- Scenario
- A report is opened in Print Preview in a database that shows the same issue on multiple computers.
- Observed behavior
- The Access window becomes unclickable and the preview ribbon does not become active until the user switches away with Alt+Tab and returns.
Confirm whether the issue occurs only in this database and whether Alt+Tab temporarily restores interaction. Close Access and make a copy of the database before attempting repair, decompilation, or object import.
Compact and repair the affected Access database
Use Access's built-in repair tool to address possible database corruption.
In Access, select File > Open and open the copy of the affected database.
Select File > Info > Compact & Repair Database and allow Access to finish the operation.
Open the affected report in Print Preview and check whether you can click the window without using Alt+Tab.
Decompile and recompile the database code
Try this on a database copy if compacting and repairing does not resolve the issue.
Import database objects into a new blank Access database
Create a fresh database container if the existing database remains unresponsive.
Use WPS Office for Everyday Documents and Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface and compatibility with common Microsoft Office formats, making it easy to move everyday document work. It does not repair Access databases or replace Access database features.

Frequently Asked Questions
Why does Alt+Tab make Access clickable again?
Switching away and back can temporarily restore interaction with the Access window, but it does not establish or fix the underlying cause. If the issue occurs only in one database, test a repaired copy or a new database container.
Where is Compact and Repair in Access?
Open the affected database and select File > Info > Compact & Repair Database. Test the report again after the operation finishes.
What if the database still freezes after compacting?
Try opening a copy with the /decompile command-line switch, then use Debug > Compile in the Visual Basic Editor. If the issue persists, import the database objects into a new blank database.
Will importing objects transfer every database setting?
Not necessarily. After using External Data to import objects, check linked tables, relationships, VBA references, and startup settings, and recreate or relink anything missing.
Can WPS Office repair an Access database?
No. Use Microsoft Access to repair, decompile, or import Access database objects. WPS Office is an alternative for common document and spreadsheet work, not an Access database repair tool.




