Solution Properties
Solution ID:
200427112321519
Last Modified Date:
Thu Aug 17 14:14:59 UTC 2023
Taxonomy Path:
Case category//How do I...//processing
Author:
anth.richardson@sage.com
Stop the Data Service or lock Remote Data Access
Description

When speaking to Sage Technical Support, there may be occasions where you need to make manual changes to your Sage 50 Accounts data files.

Before you make such changes, you must ensure everyone is logged out of Sage 50 Accounts and depending on your version, 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. Look at the centre column then scroll down to Remote Data Access information.
  4. Look at the Dataset ID.
If this has an ID you are using Remote Data Access, if it is blank you are not using Remote Data Access.


Now you know whether you use Remote Data Access, follow the relevant steps below.

Skip to:

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. 

View steps for v28 and above >

To do this:

  1. Log all users out of Sage 50 Accounts.
    To see who's currently logged in click Settings then click User Management and click Active Sessions.
  2. From the main site log into Sage 50 Accounts using the manager logon.
  3. Click Settings then click Remote Data Access Settings.
  4. Click Pause Live Sync.
  5. Make any required changes on the data.
  6. To unlock Remote Data Access, click Tools then click Remote Data Access Settings.
  7.  Click Resume Live Sync, then click OK.

NOTE: If you can't access these options, follow the section below to make the required changes as if without Remote Data Access, then delete the queue.dta file before restarting the data service.


View steps for v27 >

To do this:

  1. Log all users out of Sage 50 Accounts.
    To see who's currently logged in click Settings then click User Management and click Active Sessions.
  2. From the main site log into Sage 50 Accounts using the manager logon.
  3. Click Tools then click Remote Data Access and click Lock Remote Data Access.
  4. Make any required changes on the data at the main site.
  5. To unlock Remote Data Access, click Tools then click Remote Data Access and click Refresh Remote Data Access and click OK.

 NOTE: If you can't access these options, follow the section below to make the required changes as if without Remote Data Access, then delete the queue.dta file before restarting the data service.


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