Error: “Sage 50 is unable to connect to its database Actian Zen on computer [computer name]”

• Incorrect computer name in ~pvsw~.loc in archived companies
• Moving data from one computer to another through copy/paste rather than backup/restore

Workaround for making backups:

1. When saving a backup, uncheck the Include Archives in the backup check box.
2. Confirm that the backup will save.

Delete ~pvsw~.loc files

1. Click Maintain, Company Information.
2. Write down the Directory path.
3. Click OK.
4. Close Sage 50.
5. Browse to the directory location from Step 2.
6. Delete the file ~pvsw~.loc.
7. Double-click the Archives directory folder.
8. Open each folder in the Archives directory to locate and delete the file ~pvsw~.loc.
9. Close Windows Explorer.
10. Open Sage 50.
11. Verify you can now open your archived companies and/or back up successfully.

 NOTE: f you get an error when attempting to delete the .LOC file that Pervasive has opened, then you will need to stop the Actian service. See How to stop or start the Actian Zen database engine. 

Expendable file cleanup

Follow Create a clean data folder and expendable file cleanup.