Office Apps Freezing

Fix Microsoft Access Freezing After Opening a Report in Print Preview

Chanuka GeekiyanageChanuka Geekiyanage Nov 14, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

Compact and repair the affected Access database

Use Access's built-in repair tool to address possible database corruption.

1
Open the database copy

In Access, select File > Open and open the copy of the affected database.

2
Run compact and repair

Select File > Info > Compact & Repair Database and allow Access to finish the operation.

3
Test the report

Open the affected report in Print Preview and check whether you can click the window without using Alt+Tab.

Already tried repair?: If compacting and repairing did not help, try decompiling and recompiling the database or importing its objects into a new database. Some corruption can persist after repair.
Free Microsoft Office alternative

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.

Preview and print documents and spreadsheets in WPS OfficeOpen and edit common Microsoft Office formats, including DOCX, XLSX, and PPTXWork in a familiar interface that supports an easy transitionUse a free, lightweight office suite for everyday tasks
microsoft office alternative - wps office

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.