SMBs

Pro tip: A quick fix for slow QuickBooks data file connectivity

Follow these steps to experience a much faster connection to your QuickBooks data file.

money-cash-dollars-3697_610x407.jpg
QuickBooks is the de facto standard for small business finances. When QuickBooks runs well, it's a champ; when it doesn't, it can be a nightmare to troubleshoot.

One issue users sometimes encounter is their connection to the QuickBooks data file slows to a crawl. When this happens, work either becomes nearly impossible, or you lose data -- neither is acceptable.

If your network is humming along in its usual zippy fashion, and you've come to the conclusion that the desktop(s) are trouble-free, how do you get QuickBooks back up to speed? A quick fix that almost always solves the problems is to create a portable copy of your data file. This fix is especially helpful when your transaction logs have gotten out of hand. The transaction logs are files with the .tlg extension. For every QuickBooks data file, you will have a transaction log. If the file size of the .tlg file exceeds that of the .qbw file, problems may ensue.

When you create a portable copy of your data file, the transaction log is effectively flushed, and you start with a pseudo clean slate. This ultimately has the effect of speeding up your connection to the data file (given you have no general networking or firewall issues).

Here's how to create the portable copy:

  1. Get everyone out of QuickBooks.
  2. Switch to single user mode.
  3. Go to File | Create Copy.
  4. Select Portable Company File (Figure A) and click Next.
  5. Click the Save In drop-down and select Desktop.
  6. Click Save.
  7. Click OK.
  8. Click OK.

Figure A

quickbooks_fix_111813.png
Creating a portable copy of your data file.

The portable copy of your data file will now be located on your desktop. The next step is to restore that portable copy back to the original location. Follow these steps:

  1. Go to File | Open Or Restore Company File.
  2. Select Restore A Portable File and click Next.
  3. Locate the portable copy on your desktop and click Open.
  4. In the Where Do You Want To Restore The File window, it's very important that you read the warning about changing the file name. Click Next.
  5. Click the Save-in drop-down and select your location (this will be on the server/machine hosting the data file).
  6. Rename the file.
  7. Click Save.

If you do not rename the file, you will overwrite the existing data file. If there was a problem during the creation of the portable copy, you could overwrite your data file with a file that will not work, so use caution!

Once the file is restored, open the data file. You should experience a much faster connection to your QuickBooks data file.


About

Jack Wallen is an award-winning writer for TechRepublic and Linux.com. He’s an avid promoter of open source and the voice of The Android Expert. For more news about Jack Wallen, visit his website getjackd.net.

3 comments
chrisbedford
chrisbedford

There have been about a thousand different versions of QB since I started using it, and a hundred different ways in which the shared file is shared. OK, I exaggerate of course, but you get the idea. My point is this article should have referenced the edition (QB, QB Pro, QP Premier, QB Enterprise) and version (they started with numbers then went to years - I lost track long ago).

And then, no mention of any possible ramifications of that truncation? Might it, for instance, curtail the ability to get meaningful audit trails, or do those logs only track the actual transactions to the database while QB itself still keeps its own records of who made those transactions?

mw65
mw65

As long as you backup the database using Quickbooks built in backup facility it will truncate the log file during a successful backup.   This only applies to a manual backup though.   According to this article http://support.quickbooks.intuit.com/support/articles/INF12222 a scheduled backup will not reset the log file.