[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 995
  • Last Modified:

Quickbooks error when trying to open a database?

Hello Experts,
So I have one user who is getting an error message when trying to open our company database.  We had put the database onto a flash drive so it could be worked on elsewhere and then we put it back on the server, but this time it's inside of a folder within the main folder on the server, not that that should matter.  Our other two users seem to be able to open all the databases without a problem.  The user that I'm talking about is our owner and I'm trying my best to get this fixed, but would appreciate some help.  The error says this, "Warning We're sorry.  QuickBooks encountered a problem.  We recommend you download the QuickBooks Connection Diagnostic Tool, which can assess and possibly correct the problem.  If the problem continues, contact Support for assistance.  Error codes (-6000, -83)."

I spoke to the QuickBooks people and they said that one of those error codes mean that the database is corrupt, but as I said before, our other users can access it without a problem so I don't think it's corrupt.  We tried downloading the diagnostic tool, but it did not help.  Should I try moving the database back to the original folder where our other databases are?  Any help would be greatly appreciated.

If needed, the user's computer that is having a problem is running Windows 8.  The server is Windows Server 2008.
0
Brent Johnson
Asked:
Brent Johnson
  • 3
1 Solution
 
John HurstBusiness Consultant (Owner)Commented:
First, copy the data files (.QBW and .TLG) to a local machine where the user can access anyway. Open QuickBooks and access the local file (NOT the server file) and do a Rebuild (File, Utilities and Rebuild).  Check that this completes.

Move the Server files to temporary backup location (delete when you know all is well).

Copy the data files back to the server location (so you are replacing the data files with the rebuilt files).

Make sure this location is on the same server partition as the QB Server engine and run the server manager again to scan for the company file.

Now try to open the QB data files from the server from the good machines.

================

Now to the problem machine. Restart it, make sure the QB data folder is properly mapped (not browse) and now open QuickBooks. Use the File Open command to navigate to the server location. Do NOT use Recent files.

Does it open?
0
 
John HurstBusiness Consultant (Owner)Commented:
@Brent Johnson - did my suggestions work?  I think they should as it works for me.
0
 
John HurstBusiness Consultant (Owner)Commented:
@Brent Johnson  - Thank you for following up and I was happy to help.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now