Connect with and learn from others in the QuickBooks Community.
Join nowHello! I am having a problem that has gone on for far too long and I need help t fix. We have multiple people access two different stores we have setup. So when I go to log in every morning it always says someone is in single user mode please ask them to switch to multi. The problem here is that the chances of me locating who that is and them being at their desk is slim to none. So then I am stuck waiting and calling their phone over and over and I can't do anything until they return. Everytime when they answer they say that they just recently switched and it was in multi and everytime it has switched back to single user mode. Is there anyway to keep multi user mode as a default and only way to go to single user would be to go to file. Thanks in advance to whomever can get me my time back at work. THANK YOU
Solved! Go to Solution.
I'm here to resolve it, Mikethomp128.
The most possible reason why it keeps on switching from multi-user to single-user mode is because of the network setup. We can download and run the QuickBooks File Doctor. This will fix company files and network issues in QuickBooks Desktop. For the detailed steps, please check this article: QuickBooks File Doctor.
Aside from that, we need to make sure that your Database Server Manager is properly set up. This is the tool that allows users to access the company data. Please check this article about QuickBooks Database Server Manager and let's perform all the steps provided.
I'll always be here if you have other questions. Just leave a comment below.
I'm here to resolve it, Mikethomp128.
The most possible reason why it keeps on switching from multi-user to single-user mode is because of the network setup. We can download and run the QuickBooks File Doctor. This will fix company files and network issues in QuickBooks Desktop. For the detailed steps, please check this article: QuickBooks File Doctor.
Aside from that, we need to make sure that your Database Server Manager is properly set up. This is the tool that allows users to access the company data. Please check this article about QuickBooks Database Server Manager and let's perform all the steps provided.
I'll always be here if you have other questions. Just leave a comment below.
Thank you so much for the insanely quick response. I will be honest it’s not fixed although I am sure what you told me will work. I went to the IT Dept and now they are kicking around upgrading and the computer where QB is stored is our server so they did t want me messing with that. I must say that was a good move on their part. Ha ha thank you so much. I think you gave me something even better and that’s finally updating our system.
Hello!
I am having some trouble with the MUM and SUM. When I sign in QB automatically signs me in under Multi-User Mode. I think during set up I got to pick and I just chose that one, but now if I am in MUM I can't import time sheets, modify customer names, etc. So then I have to sign off and switch to SUM, but once I close QB and open it back up next time I'm back in MUM. Help Please!
Hello @Willis Sinclair,
Let's download and run the QuickBooks tool to fix the issues with accessing your company data.
But if you already perform these steps with the same results, you'll want to repair the QuickBooks itself.
Here's an article you can read to learn more about how you can repair QuickBooks: Repair your QuickBooks Desktop for Windows.
I've got you this helpful article in case you need some ideas about how you can restore a copy of your company data: How do I?
Keep me posted in the comments if you need more help.
Having the same issue and we've tried everything that was suggested in this post. It's to the point where we now have to run a scan in the Database Manager every morning just to get QB out of Single User Mode.
Thanks for joining us here, @majorc3rd.
I'd appreciate performing the steps outlined by my colleague. Since the issue persists, I recommend running the repair tool for QuickBooks Desktop. This tool can help fix common errors that can affect the performance of the software.
Here's how:
Note: If you're using Windows 8 or 8.1, search "Control Panel" in the Windows Start menu.
Note: If you don't see Programs and Features, select Programs instead. Then select Program and Features.
Note: The repair should start right away, but it may take a while to finish. You can leave it running, and come back once it's done.
Note: You may have to restart your computer to complete the repair.
Also, if you encounter errors when switching to multi-user mode, check out this article to fix the issue: How to fix Error H202 and H505?.
I've also added an article that'll help you learn the task you can perform when switched to single or multi-user mode: Features available and tasks you can perform in single or multi-user mode.
Keep me posted on how it goes, @majorc3rd. I'll be around to help.
I have the same issue with 2 clients using MUM. I have worked with support, tier 2 and still no resolution. Both sites are failing to stay in MUM. Is this a known issue that QB isn't reporting?
I am having the same issue. Even moved the server to a new VM host. Is this a known issue? If so anyway to fix it?
We are having the same issue. We are running version 20 but the DB Engine Version is 17.0.4.2182. Is there a DB Engine Version higher?
Thanks for posting to the Community, @ruedingerj.
Currently, this the latest Database Engine Version, and we're looking forward to checking further updates.
Since you're having the same issues and applied the steps provided by my colleagues, I'd suggest reaching our Technical Support team for follow up, and if possible to resolve earlier.
Here's how:
Please know that our staffs are limited, and our support hours are available from Monday to Friday from 6 AM to 6 PM PT.
Feel free to place a comment here after contacting them if you need further assistance or share your experience. The Community is always here to help. Take care!
We have the same issue among other things...none of which the tool hub fixes.
We run QB Desktop 2018 contractor version. It's in a Windows 10 VM (Version 1909; build [removed]) on Unraid.
#The system crashes occasionally normally when we are viewing an old receipt. Also once it crashes it comes back up as single user mode some times. It crashes at other times for inexplicable reasons.
#upon migrating to the VM...we discovered that our Loan Manager had lost all information.
#I did discover that after I had initially setup the vm and stopped hosting on the prior computer somehow the old host computer reverted back to thinking it was the host machine which was causing network issues. I even went thru the trouble to completely uninstall it on the old host machine and reinstall choosing the correct settings and it still did it.
#Using the database server manager in the VM...produces a Windows Firewall issue but does not suggest a fix and does not fix it. I've researched this and went thru a number of steps to make sure Windows firewall isn't causing the issue to no avail.
#Also in the past we have had issues with email...the VM refuses to see Thunderbird after a number of attempts of reinstalling it and/or Quickbooks. The client computers when we sign in...Thunderbird is given as an option so it's working now. Just strange.
I'm here to ensure everything is working, @jhunter844.
I appreciate all the troubleshooting steps you've taken to fix the issue. And I'd like to redirect you to the best support group available to get this resolved right away.
Since the troubleshooting steps shared by my colleagues above doesn't work, I highly recommend contacting our Phone Support Team. This way, they can further check on this matter and provide additional troubleshooting steps to get this fixed. They can also create an investigation ticket if other users experiencing the same.
To reach them, you can follow the detailed steps provided by my peer Jovychris_A above to talk or chat with one of our support agents.
As always, feel free to visit our QuickBooks Community help website if you need tips and related articles in the future.
Please know that you can always get back to this post if you have additional questions with QuickBooks. I'll be around to provide further assistance. Have a good one.
When you said you would redirect us to the best support group for this problem did you mean the helpline or did you forget to include it? I only ask because you said group so it sounded like it was more of a messenger board. Fully still having the problem E V E R Y D A Y !
Hi there, Mikethomp1281,
I can share what my colleague means about redirecting you to our support group. You can contact our QuickBooks Desktop Team via chat or callback.
They can isolate the issue since it keeps coming back after performing those troubleshooting steps provided in this thread. You can get in touch with them depending on your plan:
Let me know how the contact goes by leaving a comment below. I'm always right here to help fix the multi-user issues.
This worked for me:
Let me help you set your company file to open in Multi-user by default.
Each time you open the company file from the computer, the multiuser mode will be enabled. You can do this on every workstation.
This worked for me for having the file open in multi user by default:
Each time you open the company file from the computer, the multiuser mode will be enabled. You can do this on every workstation.
I'm with you and it would be time-consuming to check every workstation to see if it's in single-user mode. Let me help you set your company file to open in Multi-user by default.
There are two ways to open company files in Multiuser mode automatically. The first one is to check the Open file in multi-user mode option. Here's how:
Each time you open the company file from the computer, the multiuser mode will be enabled. You can do this on every workstation.
The second one is to edit the QBWUSER.INI file and then change the MULTIUSERMODE value. Due to the technical nature of this method, you might want to reach out to a computer expert.
Here's how:
There are times when the system reverts the file to the original value. To prevent this:
Please don't hesitate to reach out to me if there's anything else you need help with.