quickbooks goes to sleep
What if QuickBooks takes a nap?

Has this happened to you? I’m guessing you’ve seen it before: You’re trying to update your company, or make a backup, or verify your company, or run a big report.

QuickBooks gets off to a good start, but then seems to stall. You make a couple of clicks and Windows pipes up: “(Not Responding)”. Oh, great.

What do you do then?

Sometimes users panic, and Ctrl-Alt-Delete / Task Manager / End Task their way out of QuickBooks. That’s not a very good choice, because if you force the application closed, there’s a good chance that your data file won’t get closed down like it’s supposed to.

I guess an even worse choice, for those who maybe don’t know about Task Manager, is to turn off the computer. “Reach for the big red handle”, as we used to say in the old days. That’s not good either.

Either of these actions has a high likelihood of causing data corruption, meaning that your next step after that would be to restore a backup and rekey to get caught back up, or get your data repaired.

INTERVIEW/CASE STUDY: QuickBooks Won’t Verify or Rebuild

So what to do? Most of the time, the best approach is both the hardest and easiest: just wait.

A lot of times, QuickBooks isn’t really “frozen” or “locked up”; it’s just “thinking”. Give it some time, particularly if you are trying to do something in QuickBooks that is systematic: backing up, restoring, verifying, rebuilding, resorting, etc. Those functions in QuickBooks have to touch a lot of your data, which might amount to millions of pieces of information.

That can take some time. I don’t know why QuickBooks doesn’t have a more elegant, less stress-inducing way of communicating that to users. I never like to see Windows intervene in an application. I want my QuickBooks to respond, not to not respond!

So if you see QuickBooks do that, maybe that’s your cue to take a break. Go outside and get some sunshine, or go to your nearest coffee bar and get caffeinated. Hopefully QuickBooks will be ready to go again by the time you get back to your workstation.

TIP: How to Open QuickBooks When It Won’t Open

Then, for the future, here are some things that might help it from having to take so many naps:

* Close some of your open windows, in QuickBooks and in Windows itself.
* Reduce your file’s size
* Configure your internet security software settings so that it ignores your QuickBooks folder
* Rebuild your file to make sure that there is no data corruption in it
* Defragment your hard drive so that QuickBooks will be able to access everything as quickly as possible
* If you are using Enterprise 11, turn off the Search feature (Edit / Preferences / Search / Company Preferences / Uncheck “Update automatically”.) Then backup your data with full verify turned on. This will blank out the TLG file (which might be huge), and relieve QuickBooks of having to constantly update its search index on the fly.
* Create and then restore a portable copy backup of your file. This will reindex your file and probably enhance performance — at least temporarily — of a large file.

Have you seen the (Not Responding) message? What did you do about it?

Have you ever seen a screen like this?

I hope not!

But if you ever do find yourself unable to open your company, or it fails when you try to do certain operations in QuickBooks, there are three possibilities for recovery:

1. Restore your last good backup. Hopefully you have one that is pretty current.

Just make sure that you copy off your bad version of the data before you restore. Sound strange? Once you restore, your backup will overwrite your current data — that’s a permanent thing. So copy your bad version of the QBW file to a different location before restoring, just to keep all your options open.

If option #1 is unavailable or impractical for you…

2.  Upload your damaged file to QuickbooksUsers.com for repair. We have corrected over 10,000 damaged accounting databases since the 1980s, and our success rate with damaged QuickBooks data files is 95%.

If your QBW file is hopelessly corrupted, or is somehow even missing…

3. Upload your last good backup — even if it’s old — and your current TLG file.  The TLG file is your transaction log file and has the same name as your QBW file, but has a TLG extension. We can take your old backup and your current TLG file and bring your old backup up to date.

Most users never encounter this problem. But if you do, at least you have some options.

This error showed up over the weekend. It is associated with an update that came out in AVG’s anti-virus software. This update, 271.1.1/2832 (AVG v9.0.814) falsely detects QuickBooks as being infected with a virus.

The workaround to the problem is to set up an AVG exception so that the QuickBooks folder is not scanned.

Details are on a QuickBooks KnowledgeBase page here.

If additional help needed — a walkthrough of the process, for example — give us a call at 1-800-999-9209 or click here.