Prevent Microsoft Access Database Corruption During Windows Defender Scans
Question details
Reduce the risk of Access database corruption when antivirus scans overlap with record editing.

- 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.
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.
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.
Ask all users to close the Access database and select a time when no one will need it.
Open Task Scheduler and navigate to Task Scheduler Library > Microsoft > Windows > Windows Defender. Open Windows Defender Scheduled Scan.
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.

Use local Access front ends and check the network back end
Use this setup for a split database shared by multiple users to reduce dependence on a shared front-end file.
Review narrowly scoped antivirus exclusions with an administrator
Consider exclusions only after identifying trusted database paths and assessing the security tradeoff.
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.

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.




