Refresh the queue.dta File in Sage 50
Once you launch the Sage Accounts, there are times that it might hang on or shut on the splash window. It is then that you will receive the following message:
User Navigation
‘Queue.dta is in use Please wait until this file is available’
In case the Sage 50 Accounts closes unexpectedly, the file that holds the list of active users has not refreshed. This can lead to problems once you log back in. In this case, simply deleting the file called queue.dta and later reopening your software refreshes the list, and normally resolves the login issue. If the problem still persists, then you might need to repeat the steps in this article on each system if you run the software over a network and Refresh the queue.dta File in Sage 50.
Causes of Active Users not Refreshed
The main causes for this to happen is, if the Sage Data Service does not have complete access to your data files, or if your data is stored within a path in any of the following locations:
- C:\
- C:\Windows
- C:\Program Files
- C:\Program Files (x86)
- C:\Dev
Read More : Fix Sage Error Username is in Use the Program Cannot Connect you at this Time
Resolution to Fix the Login Issue
Before you begin:
Make sure that all the users have logged out of Sage 50 Accounts, including all Remote Data Access users.
Find the Path to the Company Data Folder
- Start by accessing the system that contains your data.
- Next launch the Sage 50 Accounts
- Now within the Company Selection window, click on the required company.
- Click on the three dots located to the left of the company name
- Now click Folder location.
- Sage 50 Accounts v26 and below – in the Select Company window and click Open the Folder Location.
- Note: Can not open the Company Selection window or folder location?
- Make a note of this folder location as you might require it later.
Stop the Sage Accounts Data Service
- Access the system that holds the required data.
- Note: In case you use Remote Data Access and you are following these steps to resolve an error message, please access the system referenced within the error instead.
- Click on the Windows Key + R on the keyboard and enter Services.msc
- Next press Enter.
- Now Right-click ‘Sage 50 Accounts vXX click Stop. For example, if you use Sage 50 Accounts v29, stop the Sage 50 Accounts Service v29.
- Note: If Stop or Start buttons have been grayed out this is down to your Windows permission on the system. You need to Right click the Services App on Step 2 and click Run as administrator. In case the issue still persists, contact your local IT to solve this for you.
Delete the queue.dta File
- Navigate to the company data folder you have located in step 1: Find the path to the company data folder.
- Next Double-click the ACCDATA folder, fins and right-click on QUEUE.DTA.
- Now click Delete.
Start the Sage Accounts Data Service
- Within the system that contains your data, you need to click on the Windows Key + R within your keyboard and enter Services.msc then press Enter
Note: If you are using Remote Data Access and you are following these steps to resolve the error message, you need to access the computer referenced within the error instead.
- Right-click the following service and click Start.
- For example, if you use Sage 50 Accounts v29, you need to start the Sage 50 Accounts Service v29.
- Log back into your system.
- If the issue continues, repeat the process on the system where the issue has taken place.
- Sage 50 Accounts Service vXX
Also Read : Unable to Run Sage 50 Accounting Setup in Server
Conclusion
If the problem persists, and you need to use the Remote Data Access, you can also remove Remote Data Access, repeat the steps in this article. Next you need to set up remote data access again. For more details be sure to visit us at www.accountinadvice.co and you are sure to find some latest information. Was this article helpful? Do let us know in the space below.
Accounting Professionals & Specialized Experts
Want quick help from accounting software experts? Get in touch with our team members who can install, configure and configure your software for you. Proficient in fixing technical issues, they can help you quickly get back to work whenever you encounter an error in Sage software. Our team is available 24/7 365 days to assist you. To get in touch.
Frequently Asked Questions (FAQs)
How can one Refresh the Remote Data Access in Sage?
In order to do this, you need to:
1. Click Tools
2. Click Remote Data Access
3. Now click Lock Remote Data Access.
4. Make the needed changes within the data at the main site.
5. In order to unlock Remote Data Access, click Tools
6. Now click Remote Data Access
7. Finally click Refresh Remote Data Access
8. Lastly click OK
How can one Clear the Old Data within Sage 50?
In order to do this, you need to:
1. Open the Tools menu
2. Next choose Period End then
3. Now click on Clear Stock. A confirm window appears, informing you that the Clear Stock option permanently removes transactions from the Stock transaction history and asks if you want to continue.
4. To continue with the Clear Stock, click Yes
How can One Update the Chart of Accounts within Sage?
In order to do this, you need to:
1. Start by Clicking on Nominal codes
2. Next click the Chart of accounts.
3. Now Click the required Chart of accounts, for example, Default Layout of Accounts, then click Edit.
4. Now Click Profit & Loss or Balance Sheet, according to which area you wish to amend.
5. Click on the required category, for example Overheads