Summary
How to resolve the error: "Unable to open the company file" during or at the end of a Sage 50 Accounting data file conversion.
Resolution
Check the file attributes
- Go to the data file location.
- Right-click the SAJ folder and select Properties.
- Select the Read-Only and Hidden checkboxes.
- Click Apply then uncheck the Read-Only and Hidden boxes.
- Click Apply again.
- Click Apply the changes to all subfolders in the SAJ folder.
- Right-click the SAI file and repeat the steps above.
- Verify that you can convert the data file.
Run the program as an administrator
- Run Sage 50 as administrator.
- Verify that you can convert the data file.
Restore from backup
- Find and restore a backup file created locally before the first conversion attempt.
- Save the backup as a new file. Don't overwrite the old one.
- Locate the new data file and open the SAJ folder and make sure there’s no conversion log.
- Conversion logs are time-stamped text files that are created when a conversion fails
- For example, 2017-06-28-16-20-55.txt - this file failed to convert at 2017 June 28 4pm
- Find a backup before this date and restore it
- Conversion logs are time-stamped text files that are created when a conversion fails
Move the file to the local computer
Ensure all files are on a local drive when converting to a new version.
- If the file is on a network, copy the file locally.
- After conversion, copy the file back to the network.
Check the SAJ folder
- Open the SAJ folder.
- Check for duplicate file names that contain:
- ibdata1 (Copie de Joe confliCt 2012-09-27) ibdata1 (Joe's conflicted copy 2013-01-09)
- accounts (1).frm, simplygroupmembership (2).frm, tbgtah01-1.frm or tbgtah01-2.frm;
- Verify the simply and mysql folder doesn’t have extra files or folders as well
- Remove all duplicates and extra files.
- Verify that you can convert the data file.
Disable antivirus, firewall and real-time scanners
- Disable the antivirus.
- If you have more than one antivirus software, uninstall them and leave only one, and disable it
- Turn off the firewall and real-time scanning.
- If you use McAfee, turn off both real-time scanning and the firewall
- If your computer is using any auto backup software to backup company data files, disable it.
- Right-click the Sage 50 icon and Run as administrator.
- Start the conversion again.
- After file conversion, re-enable any security software.
Need more help?