Access Compact Fails - McAfee Live-Scan

I work with Windows 11, Office 365 Personal and use McAfee Total Protection.

Access Compact and Repair fails when McAfee Live-Scan is activated.

Solution: Create a Live-Scan exception for Access (MSACCESS.EXE)

C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE 

Related Link: Cannot Compact And Repair Access Database – File Already In Use

That's it !

Backup Parts Database

From Parts main form select Tools > Backup Parts or Configuration > Backup Parts . . .

When the Parts Frontend is Opened a Daily Backup is created in the selected Backup folder if Create Daily Backups is enabled and a Daily Backup has not been preformed for the day.

or

When the Parts Frontend is Closed a Daily Backup is created in the selected Backup folder if Create Daily Backups is enabled and a Daily Backup has not been preformed for the day.

Selecting Run Backup with Create Daily Backups enabled will send existing same day Daily Backup files to Windows Recycle Bin.

Related Links: 

Bloat Meter
Compact and Repair Access Databases < Microsoft Link

The Bloated Size Database Alert can be modified in the Config Table or User.ini File.

click on image to view

Tips: 

For corrupted or locked Access databases, close all Parts Frontend Connections and all Altium sessions that are connected to the database, then Compact the Access database.

Microsoft Access was designed for LAN. 

MySQL was designed for LAN and WAN.

Using a Cloud Hosted MySQL Database is Recommended for Remote Multi-User Libraries.

Contact Parts to request technical support or a Free online demonstration.

That's It !