Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
M
MMiller1405
November 20, 2024
Question

Multi-User Access Serious issues

  • November 20, 2024
  • 2 replies
  • 8 views

Hello, 

I am hoping you someone here can help me. We have QuickBooks 2019Pro and the Database in on the server. I also have Our version of QuickBooks also installed on this serve. We are having serious uses with Multi-user access. We have three users and have the licenses for 5. We are having issues with these two scenarios. 

 

1) Run the Database manager on the server to enable the company file to be shared. If one user going in first then the other two can. But this user is randomly changing. I have hosting turn off on all the clients. But, somehow it seems to need a user to open it first and that changed from day to day. It also will randomly say the company file is open on a PC and it is not. I have even had it say this when all but on client workstation is trying to open the company file and the others are turned off. 

 

2) if I open QuickBooks on the server and have that version set to host the company file the workstations open in single user mode or have the "Company file is open on another pc" error again. This is turning into a daily thing no mater which way I try to share the database. Usually once we find the workstation that has to be open for that day....they all can get and and operate normally until the next day. 

 

What is the correct procedure to share a company file and not have these issues. 

 

Thank you....

MikeM 

2 replies

G
GenmarieMQuickBooks Team
QuickBooks Team
November 20, 2024

Thank you for providing details of your concern, @MMiller1405. Allow me to provide additional information and assist you in correctly sharing the company file in QuickBooks Desktop (QBDT).

 

The following are some reasons for QuickBooks multi-user mode not working: 

 

  • Possibly, the hosting settings are not properly configured.
  • A firewall or antivirus software may block communication between user computers.
  • The database server is unable to open the company file.
  • The file permissions in Windows are not configured correctly.

 

To share a company file, here are the steps to perform:

 

  1. Install the QuickBooks Database Manager on your main computer. This way, your company files will be shared with other computers over your network.
  2. Set the Windows admin rights to change your firewall settings and folder permissions. 
  3. Scan your folder using the Database Server Manager to access your file over the network.
  4. Turn on hosting on your server computer:
  5. 1. Go to the File menu and hover over Utilities.
  6. 2. Select Host Multi-User Access. Then click Yes to confirm.

 

For detailed information about hosting and multi-user mode, please visit this link: Host your company data in multi-user mode in QuickBooks Desktop.

 

You may also want to read this helpful article discussing access limits in single or multi-user mode: Tasks that can be performed in QuickBooks Desktop.

 

Let us know if you have other concerns about multi-user in QBO. The Community is always here to help you in any way we can.

D
Deity Alpha
Level 1
November 21, 2024

@MMiller1405 

You should install the trial version of QB Desktop Enterprise to isolate the problem.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement