Menu
Find entries by Category
Find blog entries by date
  May 2024  
Sun Mon Tue Wed Thu Fri Sat
    1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  

Previous    Next    Latest  

How to fix Sage error - Username is in use, the program cannot connect you at this time    
Wed, 13 Jun 2012 15:41

There are two main causes for this problem. Your entire computer or Sage 50 Accounts crashed, or a Windows update restarted your computer whilst Sage Accounts was open. If either of these things has happened to you then a way to fix it is;

  1. Click on Start–>My Computer
  2. Double click on the C:\ drive or which ever drive letter has your \Documents and Settings\ folder on and double click to go into the \Documents and Settings\folder
  3. Double click to go into the \All Users\folder
  4. Double click to go into the \Application Data\ folder
    [if you can't see an \Application Data\ folder and the first in the list alphabetically is \Desktop\ then you need to click on Tools in the menu bar, the Folder Options, then click on the View tab and look in the list for "Show hidden files and folders" and select this option, then you should be able to see the \Application Data\ folder although it might look feint or greyed out.
  5. Once in the C:\Documents and Settings\All Users\Application Data\ folder scroll down and then double click on \Sage\folder
  6. Double click to go into the \Accounts\folder
  7. Then depending on when you first setup the account click to go into that year, in my case I have a \2011\ and a \2012\ folder but my data is in the \2011\folder so double click to go into the year.
  8. You should then see a \Company.000\folder, if you have a license for multiple company accounts there may be several of these, one for each company accounts but in my instance I have a single user and single company licence so I just have one \Company.000\ so click to go into that
  9. Once in \Company.000\ click on the \ACCDATA\folder
  10. Nearly there.... I am now in the following directory:
    C:\Documents and Settings\All Users\Application Data\Sage\Accounts\2010\Company.000\ACCDATA\
  11. There will be lots of files with a .dta file extension in here, simply scroll down to until you see QUEUE.DTA and select it.
  12. QUEUE.DTA is the file that is locking you out from Sage. If it is deleted it will be recreated when you next login and no company information will be lost at all. But rather than just deleting the file, it is better practice to rename this file to something different so that if it does break something, you can rename it back to the original and no harm is done.
  13. Right click on QUEUE.DTA and choose rename.
  14. Type in a new filename, in this case I'll rename it to QUEUE.DTA.OLD and hit enter.
  15. Now try logging into Sage Account again and you should be all fixed.

Update May 2014
In newer versions of Sage the queue.dta file is located in a different place; C:\Sage\Accounts\ACCDATA

Comments  
Your comments
McAdams     Thu, 03 Oct 2013

i found the file and renamed it, it just worked like MAGIC! you are great.
 
Tony Fo     Wed, 09 Oct 2013

Thanks, this fixed the problem
 
Rebecca     Fri, 11 Oct 2013

Mine's quite an old version of SAGE so slightly different folders and locations but thank you so very, very much - fixed the problem - you're a star!
 
Mike     Thu, 14 Nov 2013

I am running windows XP service pack 3 with Sage 50 Accounts 2013, this guide above worked perfectly! Thank you so much.
 
Linda     Thu, 21 Nov 2013

Excellent.. Thanks for your help... worked fab..
 
COLIN     Wed, 27 Nov 2013

Hi running windows 7 I located the file via c:/ program files sage accdata then queue.dta deleted and still wouldn't allow login same message so I restored it and renamed it and still the same error message; if I run in safe mode I can login as normal without error message coming up ???
so a bit confused
 
Tom     Tue, 03 Dec 2013

Genius, many thanks
 
Dom Parker     Tue, 28 Jan 2014

Saved my life, what a great person :) Cheers
 
Janet     Wed, 05 Feb 2014

Thank-you very very much - all working again! - Sage should really sort this one out. I'll write to their support dept.
 
Arun Meyyappan     Wed, 12 Feb 2014

Wonderful information. It saved the Day
 
Pierre     Fri, 14 Feb 2014

Brilliant instructions. Worked perfectly. This is just a con by Sage to get you to take out support
 
johnster     Fri, 14 Feb 2014

Many thanks. SO long since I did this I couldn't remember where to go. Now perfect.

Go raibh mile maith agat!
 
Marie     Fri, 28 Feb 2014

Excellent, thank you. I found the folder in program files but your instructions were great.
 
Tara     Thu, 13 Mar 2014

Brilliant! Thank you. Worked perfectly.
 
    Sat, 15 Mar 2014

Brilliant! You're a star!

 
Paul Balazy     Fri, 21 Mar 2014

great well done, in Vista the path is:
C:\ProgramData\Sage\Accounts\2014\Company.000\ACCDATA
 
Janet     Sun, 13 Apr 2014

Thank you SO much! I was just about to do PYE when it crashed so you saved the day - brilliant!
 
Gordon     Mon, 28 Apr 2014

Many thanks for info. everything back to normal
 
Donna     Wed, 21 May 2014

I have done this in the past and it has always solved the problem. This time however there seems to be no queuedata.....any ideas?
 
Donna     Wed, 21 May 2014

I have done this in the past and it has always solved the problem. This time however there seems to be no queuedata.....any ideas?