The Accpac Guy
Odds and ends regarding the Sage ERP Accpac (Sage 300) system and other IT stuff I find useful or interesting.
Sage 300 ERP UI Container has stopped working
Ran into the most bizarre errors on a client’s installation today. Existing single user Sage 300 2016 installation with SQL 2014 Express on a straightforward dekstop PC. Client updated to Windows 10 at some point and at some point after that printing stopped working. No knows for sure exactly when as printing is only used by the accountant once a month so I can’t ascertain if Windows 10 was the cause or an update or something else. Initially it was failing with “Sage 300 ERP UI Container has stopped working” with no further message. Event log showed MSVCR80.DLL as the faulting module.
Sage 300 ERP Application Installer. A code download error has occurred.
Very often, after installing Sage 300 ERP on a new system, I’ve been presented with the following error messages when trying to open an icon within the Sage Desktop itself:
Sage 300 ERP and Windows 8
Ran into a funny issue with running Sage 300 ERP from a network location. I was completely unable to pin the program shortcut to my taskbar. This was regardless of whether I right clicked the app in the Start Page, right clicked the .exe file in the runtime folder on the shared network folder, or on the shortcut I created on the desktop:
I couldn’t even drag the .exe or shortcut to the taskbar:
This is apparently “by design”. Indeed, there are even certain executable files as well as shortcuts that contain certain strings (for example, “Help”, “Documentation”, “Install”) that are excluded from pinning!
Accpac and MS-SQL Server
Stephen Smith has written an excellent article sharing some tips and tricks for configuring Microsoft SQL for use with Sage Accpac on his blog.