File Corruption & Recovery

Prevent Microsoft Access Database Corruption During Windows Defender Scans

Steve KSteve K Nov 22, 2026 868 views

Question details

Reduce the risk of Access database corruption when antivirus scans overlap with record editing.

Prevent Microsoft Access Database Corruption During Windows Defender Scans
Product
Microsoft Access and Microsoft Defender Antivirus
Device & OS
Windows (version not provided)
Scenario
Users edit records in a split Access database with a back-end file stored on a network.
Observed behavior
The database may become corrupted when antivirus software scans the file during editing.
Before you start

Identify the front-end and back-end database paths and determine which computers or servers scan them. To check the Windows version and build, press Windows+R, enter winver, and select OK.

Solution 1Recommended

Schedule Defender scans for when the database is closed

Use this approach to reduce overlap between scheduled scans and database editing without turning off antivirus protection.

1
Choose a maintenance window

Ask all users to close the Access database and select a time when no one will need it.

2
Open the scheduled scan

Open Task Scheduler and navigate to Task Scheduler Library > Microsoft > Windows > Windows Defender. Open Windows Defender Scheduled Scan.

3
Set the scan trigger

On the Triggers tab, add or edit a trigger for the maintenance window, then select OK. An administrator may need to make this change if the task is managed by an organization.

Schedule Defender scans for when the database is closed
Real-time protection remains active: Changing a scheduled scan does not prevent real-time antivirus checks while the database is open. Do not permanently disable Defender.
Free Microsoft Office alternative

Use WPS Office for compatible documents and spreadsheets

WPS Office is a free, lightweight alternative for everyday Office files, with a familiar interface and compatibility that makes moving documents and spreadsheets straightforward. It does not replace Microsoft Access or fix Access database corruption.

A familiar interface for working with documents, spreadsheets, and presentationsCompatible with Microsoft Office formats including DOCX, XLSX, and PPTXA lightweight option for reviewing spreadsheet data alongside Access workflowsFree tools for common office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Should I turn off Microsoft Defender to protect my Access database?

No. Keep antivirus protection active and schedule scans for periods when the database is closed. If exclusions are necessary, have an administrator assess a narrowly scoped exclusion for a trusted path.

Where should the front-end and back-end files be stored?

Give each user a local copy of the Access front end and store the shared back end on a reliable network location. Use External Data > Linked Table Manager in Access to review linked table paths.

Will changing the scheduled scan stop all antivirus checks?

No. Rescheduling Windows Defender Scheduled Scan in Task Scheduler changes that task's timing; real-time protection can still check files while they are in use.

How can I find my Windows version and build?

Press Windows+R, type winver, and press Enter. The dialog displays the Windows version and OS build.