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:
- Hold down the Windows key and press R, in the Open box, enter CMD then click OK.
- 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.
- 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. - 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.
Version | Company file location |
---|
Sage Accounts v29 | C:\ProgramData\Sage\Accounts\2023 |
Sage Accounts v28 | C:\ProgramData\Sage\Accounts\2022 |
Sage Accounts v27 | C:\ProgramData\Sage\Accounts\2021 |
Sage Accounts v26 | C:\ProgramData\Sage\Accounts\2020 |
Sage Accounts v25 | C:\ProgramData\Sage\Accounts\2019 |
Sage Accounts v24 | C:\ProgramData\Sage\Accounts\2018 |
Sage Accounts v23 | C:\ProgramData\Sage\Accounts\2017 |
Sage Accounts v22 | C:\ProgramData\Sage\Accounts\2016 |
Sage Accounts v21 | C:\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:
- Check that the following files exist and if not, run a repair install to create them.
File | Location |
---|
Sg50Application.dll | Program directory, by default:- 32 bit - C:\Program Files\Sage\Accounts
- 64 bit - C:\Program Files (x86)\Sage\Accounts
|
msxml3.dll | System32 folder |
- Press the Windows key + E then browse to and double-click the Sg50Application.dll file.
- Click Show apps then scroll down and click Look for another app on this PC.
- Browse to the following folder:
32 bit - C:\Windows\System32
64 bit - C:\Windows\SysWOW64
- Select regsvr32.exe, click Open then click OK.
- 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:
- Right-click the program shortcut then click Properties then click the Shortcut tab.
- At the end of the entry in the Target box, add the text -SBDSingleApp
-SBDSingleApp is case sensitive.
- 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]