Advanced troubleshooting - Sage 50 Accounts hangs or closes on the splash window
Description

Before you following this article, please follow the steps in our main help guide

For some of the steps in this article you need to be able to remove or rename certain files and folders. If you're not confident with such processes, we strongly recommend that you work with your local IT Support.

Cause
Resolution


Check for data related issues

To check if the issue is data related, see if you've the same problem when opening demodata. 

To open the demonstration data:

  • Open Sage 50 Accounts and in the Select Company window select Demonstration Data then click OK

 If the demonstration data option doesn't appear, browse to C:\ProgramData\Sage\Accounts\ and delete the sage.ini file.

If the same problem doesn't occur, this indicates it is an issue with your company data, which may be corrupt. You may need to restore an error free backup as a new company.

If the same problem occurs opening demodata, continue to the next section.


Check for environmental related issues

  • If there are any other Sage 50 Accounts shortcuts on the desktop, try these first.
  • Check if you can open Sage 50 Accounts via the Windows Start menu.
  • If the data is held locally, ensure there's at least 1Gb of free disk space on your local drive. Show me how>>
  • Make sure Internet Explorer is installed on your computer. If Internet Explorer has been removed, this may cause Sage Accounts to stop working. Internet Explorer doesn't have to be set as your default browser.
  • Ensure that none of the following Sage Accounts program folders and files are locked, flagged as read-only or hidden: If you're using a 64-bit version of Windows, replace Program Flies with Program Files (x86).
    • The Sage Accounts program directory, by default C:\Program Files\Sage \Accounts
    • C:\Program Files\Common Files\Sage SBD
    • C:\Program Files\Common Files\Sage Line50
    • C:\Program Files\Common Files\Sage Report Designer 2007
    • C:\Program Files\Common Files\Sage Shared
    • C:\Program Files\Sage EBanking
    • C:\Program Files\Sage\AccountsService - v21 and above
  • Try logging on to the computer as a different Windows user. If this works, there may be a permissions issue with the problem user. If you're not sure how to do this, please contact your local IT support.

Corrupt sage.query.engine.datasource files

To delete these:

  1. Hold down the Windows key  and press R, in the Open box, enter CMD then click OK.
  2. Enter cd\ then press Enter.

    If the drive letter displayed isn't C: you must change this. To change the letter type C: then press Enter.

  3. Enter del sage.query.engine.datasource* /s then press Enter.

    This may take a few moments, when the search and removal is complete the C:\> prompt is visible in the window.
  4. Enter exit then press Enter.

Check if you can now open Sage 50 Accounts.


Check the path in the Company file

If you've already noted the path in the Company file, click Next to proceed to the next ste.

Browse to the Company file, open it with Notepad and make a note of the data path.

The Company file is located as follows:

ProgramData is a hidden folder. To display hidden files and folders, click View then select the Hidden items check box. On your keyboard press Alt then click Tools then Folder Options then the View tab and select Show hidden files and folders then click OK.

VersionCompany file location
Sage Accounts v29C:\ProgramData\Sage\Accounts\2023
Sage Accounts v28C:\ProgramData\Sage\Accounts\2022
Sage Accounts v27C:\ProgramData\Sage\Accounts\2021
Sage Accounts v26C:\ProgramData\Sage\Accounts\2020
Sage Accounts v25C:\ProgramData\Sage\Accounts\2019
Sage Accounts v24C:\ProgramData\Sage\Accounts\2018
Sage Accounts v23C:\ProgramData\Sage\Accounts\2017
Sage Accounts v22C:\ProgramData\Sage\Accounts\2016
Sage Accounts v21C:\ProgramData\Sage\Accounts\2015

Register the relevant Sage files

For Sage software to open successfully, certain files must be registered in Windows. These files are usually registered automatically as a part of the installation routine but it's possible that this didn't happen. Instead they should be manually registered:

  1. Check that the following files exist and if not, run a repair install to create them.
    FileLocation
    Sg50Application.dllProgram directory, by default:
    • 32 bit - C:\Program Files\Sage\Accounts
    • 64 bit - C:\Program Files (x86)\Sage\Accounts
    msxml3.dllSystem32 folder
  2. Press the Windows key + E then browse to and double-click the Sg50Application.dll file.
  3. Click Show apps then scroll down and click Look for another app on this PC.
  4. Browse to the following folder:

    32 bit - C:\Windows\System32
    64 bit - 
    C:\Windows\SysWOW64

  5. Select regsvr32.exe, click Open then click OK.
  6. Repeat steps 2 to 5 for the msxml3.dll file.

If the files fail to register, please proceed to the following steps.


Amend the Target in the Shortcut properties

Sage 50 Accounts v24 or below - The problem may be caused by a conflict with another SBDDesktop program. This can be tested by amending the shortcut properties and adding a –SBDSingleApp switch to the Target line in the shortcut properties:

  1. Right-click the program shortcut then click Properties then click the Shortcut tab.
  2. At the end of the entry in the Target box, add the text -SBDSingleApp

    -SBDSingleApp is case sensitive.

  3. Click Apply then click OK.


Check your Region and Language settings

If your Regional annd Language settings are set incorrectly, this might cause problems in Sage 50 Accounts.

For details of haow to set them correctly, please refer to the Date format problems article.


[BCB:19:UK - Sales message :ECB]


Steps to duplicate
Related Solutions