This article provides instructions to solve the problem of Sage 50 2017 Pro Accounting not being able to open company files. Sage 50 Pro Accounting is subscription-based, versatile business solutions software that allows small and mid-sized companies to manage and automate their payroll, accounting, and HR functions. It provides cloud functionality, which makes data accessible from anywhere and collaboration possible. Sage 50 lets companies manage their employees more efficiently.
In Sage 50 Pro Accounting 2017, users may not be able to open the company file and message might be displayed stating that due to an error in connecting to a database the file can’t be opened.
NOTE: If a new sage 50 version was installed on the computer, users must update the ‘Connection Manager’ in the server.
Solution 1: Data file is present on the server computer
First step: Testing with Sample Company: Users must open the company location found at this location-
- Windows XP– C:\Documents and Settings\All Users\Documents\Simply Accounting\201X\Samdata\
- Windows Vista/7/8– C:\Users\Public\Public Documents\Simply Accounting\201X\Samdata\
Second step: If the sample company can be opened without any errors, these steps must be taken:
- First, users must check the firewall of the server hosting the data is configured correctly.
- NOTE: It is very crucial to include the ports that allow communication with the Communication Manager.
- Next, users must check whether the company is on a server and in which drive. It is possible that the programs have been installed in C: drive and the data in D: drive. Then, the permissions of the folder containing the data must be checked.
- Next, a new shared folder must be created at the root of C:\, and the data must be transferred to this folder. Then, full permissions must be granted to all users.
- Now, users must try to access the data from the new folder. The data file must be accessed via the server’s IP address and not the computer’s name.
Third step: If sample file can’t be opened
- If the data could be opened earlier, all the computers containing the data must be restarted. All firewall, anti-virus must be checked for Sage 50 processes that have been blocked. If any have been blocked, they should be provided complete access.
- Windows XP-if the sample file doesn’t open after firewall/antivirus configuration is done, there might be an issue with the Microsoft .NET framework and it should be repaired.
- Windows Vista/7/8-if the sample file can’t be opened, the .NET components of the operating system are damaged.
Solution 2: Data file is in C:\PROGRAM FILES\ (or C:\PROGRAM FILES (x86)\)
- In case the data file is located in C:\Program Files\ (or C:\Program Files (x86)\) and the sample company file can be opened, then users must transfer the.SAJ folder and.SAI file out of C:\Program Files\ (or C:\Program Files (x86)\).
- For example, the.SAJ folder and.SAI file can be moved to C:\MySageData\.
- Next, the SAJ folder must be right-clicked and ‘Properties’ chosen. The ‘Hidden’ and ‘Read-only’ boxes must be unchecked. Then, the ‘Security’ tab must be chosen.
- Next, all Groups or usernames that are listed must have ‘Full Control’ access privileges. If users are unable to do this, they must seek an IT expert’s help.
- Then, users must choose OK and the SAJ folder must be opened. Here, users must find the process.pid file and delete it. Then, it must be checked if the data file can be opened.
Solution 3: ODBC issue must be checked
- Users must check that ODBC is installed by navigating to Control Panel and then to ‘Programs and Features’or ‘Add Remove Programs’. Users must check if ‘MySQL Connector/ODBC 3.51’ and ‘MySQL Connector/ODBC 5.2(a)’ are installed.
- If installed, users must users must check resources on detection of data inconsistencies.
- If not installed, ODBC must be installed by going to ‘C:\Sage\Sage 50 Accounting <version>\BIN\MySQLODBC\ ‘.
- Then, the ‘mysql-connector-odbc-commercial-<version>.exe’file must be run.
Solution 4: Restoring default factory settings on a new computer
Users must restore Windows Vista/7/8/10 factory default settings using the computer maker’s restore disk.
Solution 5: Restoring points if the computer isn’t new
- The restore points of Windows Vista/7/8 must be used for restoring the computer to a previous status when Sage 50 was functioning normally.
- Users must go to the Control panel and then ‘System’ or ‘Recovery’ for finding the restore points. The Wizard must be used for locating the restore point where the .NET components were updated.