What to do when QuickBooks file gets corrupt?

-
It is common to see corruption in QuickBooks due to various reasons like hardware failure, improper system shutdown, virus attack etc. When QuickBooks file gets corrupt all your data in it  become inaccessible, sometime even cannot open file. So  if you won't handle corruption properly, you may lose your precious data. To overcome corruption, you can use inbuilt utility provided by Intuit QuickBooks support but how will you know that what are the reasons for corruption. So here I am describing some of the symptoms for QuickBooks file corruption:


  • Your Company file won't open.
  • You receive strange error messages.
  • You cannot access data.
  • When you try to save a transaction, QuickBooks shutdown.
  • You can not save your data.
  • Transactions are missing.

Once you have found that your file gets corrupted, run Verify & Rebuild Data tool to repair your damaged file.

Verify Data: As its name suggest, it verify & detect damaged file of your company. Run this tool in the single user mode on the same computer on which your data is placed.

Run Verify Data: Following are the steps to run Verify tool:
  1. First close and then reopen your QuickBooks file.
  2. In the QuickBooks menu bar, click Windows-> Close All. (It will close the all open window of QuickBooks.)
  3. Select File-> Utilities-> Verify Data.
After running Verify tool, you may receive any of the following message:
  1. QuickBooks detected no problem with your data: It means your company file is not damaged.
  2. Your data has lost integrity: It means your QuickBooks file is damaged and you need to run Rebuild Data to repair your file.
Rebuild Data: Rebuild Data tool mainly repairs transaction in your company file. It first tests each transaction in your company file and then it will do one of the following activity:
  1. Do nothing to the transaction.
  2. Repair the transaction.
  3. Delete the transaction.
Note: If your company data file is placed on your server and only QuickBooks data manager is installed on your server then you have following two options:
  1. First copy your data file to a local computer, run Rebuild Data on the same computer and then again copy your data file back to server.
  2. Install the full QuickBooks program on your server and then run Rebuild Data tool.
Run Rebuild data: Following are the steps to run the Rebuild Data tool:
  1. First sign in to your data file as the administrator.
  2. Go to QuickBooks menu bar, click Windows-> Close All.
  3. Again in menu bar, select File-> Utilities-> Verify Data.
  4. Click OK on the warning message.
  5. Now select Local Backup from Create Backup window.
  6. Choose a path and folder for the backup by clicking on the Option button.
  7. Click on Complete Verification and then click OK.
  8. Click Next.
  9. Enter a file name in the Save Backup Copy window and click Save.
  10. QuickBooks will first start the backup and then Rebuild Data tool.
  11. When Rebuild finishes it will display a message which says “ Rebuild has completed”.
  12. Click OK.
  13. Now close and re-open your company file to refresh the list.
  14. Again run Verify data and if it fails then run Rebuild data.
  15.  If Verify Data completes, you will see a message saying “ QuickBooks detected no problem with your data.”

Comments

Post a Comment

Popular posts from this blog

How to Fix Issues with Excel File Save

-
Sometimes users face problem in saving Microsoft Excel files. Excel shows different type of error messages while saving the file such as “Errors were detected while saving C:/Users/Filename.xlsx”, “an error message indicating the document was not saved or that someone else is using the file and can’t be saved”. You may face these types of issue while saving Microsoft Excel files if one or more of the following conditions are true. You have limited permissions to a network drive and you are trying to save an Excel file there. You do not have sufficient drive space and trying to save an Excel file to that location. While saving the Excel file, you have lost the connection to the file. Antivirus software program arise conflicts with the Excel file save. You are trying to save a shared Excel file. The path length for the Excel file exceeded than 218-characters. Excel file is damaged or some data in the file is corrupt. Here are some methods to troubleshoot Excel saving prob...
Read more

Ways to prevent corruption in FileMaker database

-
Image
Corruption in any type of database is impossible to avoid completely, even most secure and safest relational database like FileMaker Pro also got corrupt sometime. However you can still avoid corruption in FileMaker Pro to a certain limit, if you take necessary precautions. So let's first understand why FileMaker Pro got corrupt at first place. Reasons of corruption in FileMaker Pro: Since FileMaker is disk based application, so it just transfer the data as needed in main memory instead of loading the entire database. When it transfer data from main memory to hard disk and you unexpectedly quit the application then it is most likely that your FileMaker database becomes corrupt.
Read more

How to resolve Excel error “MS Office Excel is waiting for another application to complete an OLE action"

-
Image
It is not uncommon to receive error messages in Excel. Sometime these error messages are so strange and weird that it becomes very difficult to understand them. Today I will talk about one such error in Excel. “MS Office Excel is waiting for another application to complete an OLE action.” The above error may occur when you try to open your Excel sheet. There are three main reasons for the occurrence of this error: This error may occur when you use 'Send as Attachment' option of Excel to send the Excel sheet as an email attachment. If Excel is trying to access data from an active application. You have added too many add-ins in your application.
Read more