You may find Quickbooks getting confused about who can log in as multi-user and single user and occasionally find that some users are working perfectly fine in multi-user mode while others cannot access Quickbooks while it claims there is a user logged in as single user mode. Weird, yeah.

Errors 1000 and 1026 are logged by Windows Event

Faulting application name: QBCFMonitorService.exe, version: 31.0.4005.0, time stamp: 0x607177dc
Faulting module name: KERNELBASE.dll, version: 10.0.14393.1770, time stamp: 0x59bf2bcf
Exception code: 0xe0434352

There are several Web sites with fixes ranging from checking whether the Quickbooks files is shared to asking you to set the QBCFMonitorService.exe to automatically restart. To me this is ridiculous as the application should not be crashing in the first place.

There are three things we need to do to ensure that QB works well. The first is to make sure that the DB server is the ONLY server that is running QB database hosting (sometimes users turn this feature on on their desktops). The second is to maker sure that QB is updated and that everybody is running the same revision, and the last thing is to make sure the operating systems and Quickbooks files are not corrupted.

Making sure QB Revisions are the Same

Install the full QB software on your server together with the database server manager. I know you should be able to just install the database server manager to keep the installation to a minimum but I have found that it’s important to have the ability to open Quickbooks from the server and keep the company file open and locked in multi-user mode.

Once Quickbooks is installed on the server, select help –> update Quickbooks desktop and update your quickbooks to the latest iteration.

image

Once you have completed the update, restart Quickbooks to allow the updates to install.

After installing the updates, press F2 and make a note of the revision you are running on the server.

image

Next, run Windows updates and allow your server to apply the latest .Net framework patches.

From the server, open the Quickbooks file in multi-user mode and leave it running. This prevents someone in the office logging in to Quickbooks in single user mode first thing in the morning and locking everybody out. Yes, this still happens.

Next, open each and every Quickbooks desktop client and apply the updates. As in the previous step, press the F2 key after applying the updates and verify that all Quickbooks client PCs are running the same revision.

There can Only be One

The Quickbooks server can be the only one running the multi-user hosting. Check the Server by pressing the F2 key within Quickbooks and scrolling down to the bottom. The server name, IP address and ports should be displayed, as shown below, indicating that it’s hosting the Quickbooks file.

Basically this means that this is the database server which is hosting multi-user (acting as an intermediary between the data and the Quickbooks desktop users). There can only be one, if there are other PCs hosting multi-user, the feces will collide with the thermantidote.

image

Check each Quickbooks desktop PC to make sure that multi-user hosting is turned off. From withing Quickbooks, press the F2 key and scroll to the bottom. As shown in the image below, hosting should be OFF.

image

If hosting is NOT off, click on the file –> utilities menu in each client and select ‘stop hosting multi-user access’ in order to turn off multi user hosting. Remember, ONLY the server should be hosting multi-user access.

Once you have checked that all the workstation are not hosting multi-user access, you can begin to use Quickbooks.

If you are still having problems, the final step is to check that the operating system files, the Quickbooks files and .Net Framework are all working and free of corruption.

Checking Corruption and Reimaging

If the prior steps did not fix the issue, you may have corrupt operating system files or Quickbooks files which can cause program crashes, dropped sessions and problems with multi-user access. The following steps should be performed from both the server and each desktop PC that has Quickbooks installed.

Open a command prompt as an administrator and type

sfc /scannow

This command will check your operating system for corrupt files. if the scan finds corrupt files, followi it with an image repair by running the following command:

DISM /online /cleanup-image /restorehealth

image

This command will reimage important operating system files and restore your PC’s health.

Next, run the Quickbooks installation diagnostic tool which can be found in the Quickbooks Tool Hub. This tool will reinstall/repair the Quickbooks components including .Net Framework.

After you have downloaded and installed the Quickbooks Tool Hub, run the Quickbooks Program Diagnostic Tool.

image

Allow the program to completes, run the Quickbooks updates again to ensure that the server and desktops have the same revision. Running the diagnostic tool may revert the Quickbooks revision to a prior version, so it’s important to update again.

If after following the above steps (and ensuring that you are running a version of Quickbooks on an approved operating system) you still have problems, you may want to start looking at the network cabling, switches, network drivers, etc. as a possible cause.

Leave a comment

Your email address will not be published. Required fields are marked *