Site Map
 2010/09/08 03:00
Windows Tricks
Quickbooks ate my data

Rebuild and Reverify Steps:

Rebuild the file by selecting the “File” menu > “Utilities” > and then “Rebuild Data”.
The utility will first prompt to backup the QB file unless one was just run. Run the backup
and, then click “OK” on the next dialog confirming a rebuild of the data file. Again, this
step should only be performed on a local (C:\) copy of the .QBW file, as a networked file
is likely to be corrupted in the event of a connection failure.

Before running the Verify tool again, rename the QuickBooks log file. This file, always
named QBWIN.LOG, can be found by searching or by looking in the installation folder for
QB (usually C:\Program Files\Intuit\QuickBooks ##\, where ## is the version year) and
there is one of them for each version/year of QB installed on a computer. I prefer to
keep the file name and just add a date, such as QBWIN-2008-02-29.LOG. Now rerun the
Verify utility via the “File” menu > click on “Close Company/Logoff” and then pull
down the File menu again > click Utilities > click “Verify Data” and then select
the correct .QBW file from the computer or server drives.


Correcting Continuing Errors or Missing Data:

Open the new QBWIN.LOG file, created by the Verify utility after renaming the old one.
Programs like WordPad or Notepad, included for free in Windows, are much better than using
Word which may reformat the text. Any errors found in QuickBooks will be listed in this file.
Any items that contain the word “CHECKPOINT” can be ignored. Scan other items in the file to
identify any QB transactions that were picked up by Rebuild. Those items include some combination
 of Amount, Date, Document Number, or Transaction Type.

Once the transations with errors have been identified open the QB file and go to the “Edit”
menu > “Find” > “Advanced” button. In the Advanced Search use the Amount, Date, Document Type,
and Transaction Type to find individual transactions in the QB file. Manually delete each
transaction from the log file and reenter. Once all the transactions found in QBWIN.LOG
have been reentered close the file and rerun the Verify utility. Odds are that there will
be no more problems after a manual repair. If there are any more problems found then restart
these instructions at the Rebuild step.

 
Go to top of page