Summary
Sage BusinessWorks displays Status 46 errors when antivirus, backup software, or file permissions block database access. Resolving file locks and system conflicts restores normal processing in Sage BusinessWorks.
Resolution
To prevent possible data issues caused by the error, follow the steps below to analyze, troubleshoot, and resolve the Status 46 error.
Analyze when the error occurred
Determine when the Status 46 error appeared to guide recovery.
- During posting:
- The transaction didn’t complete.
- Restore a backup from before the error.
- If you don’t restore, General Ledger can go out of balance. You'll need to resolve General Ledger Out of Balance issues before continuing.
- During close or rebuild:
- Restore a backup from before starting the process.
Resolve antivirus and backup software conflicts
Antivirus or backup tools often block database file access.
- Exclude all mkd and ddf file extensions from antivirus scanning.
- Use scheduled backups only, not continuous, incremental, or differential backups.
- Disconnect external backup drives during daily processing.
- Some software continues background activity even when scheduled.
- Uninstall problematic software if needed, such as Carbonite, Kaspersky, or Trend Micro.
Clear stuck users or tasks
Stuck sessions can lock database files.
- Use the DBRegister Utility.
- Disconnect stuck users or tasks.
Close open files on the server
- Check for open files in Computer Management on the server.
- Close any open Sage BusinessWorks files.
- Restart the server if the files remain locked.
Remove read‑only file attributes
- Open Windows Explorer.
- Browse to the Sage BusinessWorks data directory.
- Open the company folder.
- Press Ctrl + A to select all files.
- Right‑click and select Properties.
- Clear the Read‑only checkbox.
- Click OK.
Clear temporary files
- Browse to C:\Users\[USERNAME]\AppData\Local\Temp.
- Delete all files in the Temp folder.