Stop the Data Service or lock Remote Data Access
Description

There may be occasions where you need to make manual changes to your Sage 50 Accounts data files.

Before you make changes, ensure everyone is logged out of Sage 50 Accounts and you should also stop the Remote Data Access Service, or lock Remote Data Access if you use it.

If you're unsure how to do this, we'll explain how in the steps below.

Cause
Resolution

Before you start

Before following the steps below, you need to check whether you're using Remote Data Access.
  1. Log in to your company.
  2. Click Help, then About.
  3. In the Remote Data Access section, check the Dataset ID.

If this displays an ID you're using Remote Data Access, if it's blank you're not using Remote Data Access.

 


I use Sage 50 Accounts with Remote Data Access enabled

Before you can make any changes to your data files, to protect the integrity of your data you must lock Remote Data Access to prevent anyone accessing the data. 

 

 


I use Sage 50 Accounts without Remote Data Access

Before you can make any changes to your data files, to protect the integrity of your data you must stop the Sage Accounts Data Service on the computer where the data is held, to prevent anyone accessing the data.

  1. Log all users out of Sage 50 Accounts.
    • Sage 50 Accounts v27 and above - to see who's currently logged in click Settings then click User Management and click Active Sessions
  2. On the computer where your data is held stop the data service:
  3. Click the Start menu and click All programs then click Sage Accounts and click Data Service Manager.
  4. Click Tools then click Data Service Manager and click OK.

    TIP: You can also access the Data Service Manager with Sage 50 Accounts, click Tools then click Data Service Manager and click OK, if required, create a backup then close Sage 50 Accounts.

  5. Check that the correct Server name appears in the Server box, you can amend this if required. If you're unsure of your server name, contact your IT administrator.
  6. Click Connect then make sure all users have logged out of Sage Accounts. A list of still logged in users is shown at the bottom of the window.
  7. Click Stop Service.

    NOTE: You can start and stop the service like any Windows service using your operating system. To do this, press the Windows Key + R on your keyboard > enter Services.msc > right-click Sage 50 Accounts Service > Start, Stop or Restart as required.
  8. Make your required changes.
  9. Start the Sage Accounts Data Service on the computer where your data is held.
  10. On the computer where your data is held > Start menu > All programs > Sage Accounts > Data Service Manager.
  11. Tools > Data Service Manager > OK.

    TIP: You can also access the Data Service Manager with Sage 50 Accounts. Click Tools > Data Service Manager > OK > If required, create a backup > close Sage 50 Accounts.

  12. Check that the correct Server name appears in the Server box, you can amend this if required > if you're unsure of your server name, contact your IT administrator.
  13. Click Connect > Start Service.

    NOTE: You can start and stop the service like any Windows service using your operating system. To do this, press the Windows Key + R on your keyboard > enter Services.msc > right-click Sage 50 Accounts Service > Start, Stop or Restart as required.
[BCB:95:Accounts - RDA_hub:ECB]  [BCB:91:Support message - RDA / Drive chat:ECB]
Steps to duplicate
Related Solutions