How do I stop Quickbooks 2009 from occasionally not opening for users unless first opened on the server
Posted on 2010-08-17
Occasionally users can't open a company file unless it is first opened on the server.
There are 2 users, each on their own pc. The company file is on a 2003 Server. It is set to host the file.This problem occurred today after there was a power outage yesterday.
Upon trying to open the Quickbooks company file the clients get an error message that states something like "although this file is shared for use Quickbooks is unable to open this file. Check the firewall etc, etc, etc (sorry, I didn't get the error message and number. I may have saved it as a jpg and will try to post later)
The thing that fixes this problem is to go to the server and open quickbooks. After that I log into the company file from the first machine, but I have to switch to multi-user mode from there or the other user can't get in.
They had this problem recently and I noticed that one of the users (not the server) was hosting the file. Even though they didn't have the file entered in database manager. I suppose this came about because when you get the previously mentioned error message you have the opportunity to do an "alternate configuration" which may change the hosting. I'm the new IT guy there so I don't know how that came about, but I turned off hosting on the client pc's and set the server for hosting, making sure the folder the company file is in is added in Database manager.
I'm wondering if there are some lingering .nd files or something that I need to delete. Maybe caused by the sudden shutdown after power failure. This configuration had been working fine for over a month now, until this.