QuickBooks is finicky about the network connection to the data file. This is probably the most common issue, as well as the most challenging to troubleshoot. 3: You lose the connection to the data file So before the rebuild, copy the data file to the C:\ drive, do the rebuild, and move the data file back where you need it. That means even if your data file is on the Q:\ drive (and that Q drive is on the local machine but shared, so QuickBooks THINKS it's on a different drive), QuickBooks could have an issue with the rebuild. QuickBooks is insistent that the data file be located on the C:\ drive. If the rebuild simply won't work, you might want to make sure that data file is located on the local machine. If you do find yourself in a situation where you have to rebuild the data, do it in this order: Back up your data file, verify your data file, rebuild your data file. But when dealing with the file that holds the keys to the company's financial kingdom, others will hesitate. In this case, you will have to go back to the older version and do a rebuild of your data.
Sometimes, that verified data still will not upgrade to the newer version.
Better yet, install the new version side by side with the old version so you will always have a fallback. However, to avoid any issues with the data file, make sure you run a verification on that file before you uninstall the old version or install the new version. Usually this will happen during the installation process and will require you make a backup first. Because of this, the data file must be updated. When you are upgrading QuickBooks from one version to the next, sometimes the earlier version's data file can't be read by the newer version.
Note: This article is also available as a PDF download. These tips may help you solve those issues before you lose your hair or your money. I do a lot of work on QuickBooks and have gathered some of the common issues I deal with almost daily. This complexity means that QuickBooks is prone to having problems. But QuickBooks is also a fairly complex application. It helps organizations manage their money, pay their employees, and pay their bills.
If only one person will get into each file at a time you can leave them in single user mode.QuickBooks is a crucial tool for businesses. The multi user access mode is simply something you have to set if multiple people will have the same file open at the same time. This extra layer helps to protect the data file if the workstation computer crashes or you have multiple users accessing the same file. Its a fairly passive process in that you just access the data file and don't have to do any special configuration on the workstation PC. Instead of a direct file access all data read and written from the file go through the database server. After that anytime a computer opens one of the data files on that computer the database server software will act as an intermediary. Once the database software is setup you configure the folders on the computer where the quickbooks data files are stored. (You can install the quickbooks software on there if you will be using it but don't have to). Pick your machine that will store the data files and install the quickbooks database server on that computer. You don't have to tell the machines anything about the files.