Windows Vista Networking QB2007 freezes when switching between companies

Hello Help_please,

Welcome to the community forums. I would need to get a little more information from you before we will be able to determine the root cause.

• You mention that you have more than one company file that you switch to during the day, is it always a specific data file that locks up? (ie. switching to Company A locks up but not Company B)


• Can you close a company by going to File > Close Company does it lock up?


• Can you give me a little info on how you have everything configured? (ie. data file and data file server installed on a server with 3 client PCs accessing the server)


• How much RAM, Processor speed, processor type (intel p4, AMD 3800+)?

In a multi-user environment QuickBooks will put things in Queue for deletion if you delete things throughout the day and then will run these deletions and other tasks when closing the company file. I don't think you get a message that it is performing these funtions, and it could appear to be locked up especially if you have a slower computer. How long have you waited before manually rebooting?

Thank you,

No, we have more than one file that we switch to and all lock up.

Yes, we can close the company. The problem is going into the next company. (I have noticed that a green bar scrolls along the folder where the file(s) are stored viewing on non-host computer) Remember, we are running on Vista. We did not have this issue running on XP.

Data file is stored on PC-1 (host) and PC-2 (non-host) accesses through shared folder - with Vista we found it necessary to have PC-2 logon to PC-1 as a user to access the folder. Connection is through a server running Windows 2000 Server.

Both Systems are AMD Athlon 64 X2 Dual-Core 3800+, 2GB Ram, 160GB Hard Drive.

Since I posted this, we have found that if we literally wait 15 minutes, we can eventually go into a second file; however, switching a third time usually locks it up.

PC-1 (host) has no issues changing files. We also did not have this issue when running on XP which leads me to believe that this problem is related to Quickbooks running on Vista.

I truly appreciate your interest in resolving this issue.

Thanks!

I have been having the same type of problem. The olny way that I can acess files is to be rebooting and crossing my fingers. Paid tech support has been absolutely no help. This problem started about 2 weeks ago. I'm wondering if it has anything to do with the latest update. If you have a solution PLEASE post.

Hello Help_please,

Thank you for writing back with more information on your issue. I'm going to give you a couple things to try to see if it's just a glich in the program, but it sounds like it has something to do with network because you can open and close companies on the hosting computer without problems. Try the following:

1. Close QuickBooks.
       
   
2. Click the Windows Start button, click Settings, and then click Control Panel.
       
   
3. Double-click Add or Remove Programs.
       
   
4. Locate your QuickBooks installation and click to select it.
       
   
5. Click Change/Remove.
       
   
6. Click Next in the QuickBooks Installation window.
       
   
7. Click Repair, click Next, and then click Repair.
       
   
8. Once the repair has completed, click Finish.
   

You don't need to re-register after repairing your QuickBooks installation.

If you are still having problems you can use Reboot.bat to register all the QuickBooks .dll files.

    

1. From the QuickBooks installation directory C:/Program Files/Intuit/QuickBooks 2007, locate Reboot.bat.
       
   
2. Double click on the file Reboot.bat to register all of the QuickBooks .dll files.
       
   
3. Open QuickBooks to see if the issue is resolved.

Are you working over mapped drives? If you are I would like you to try it without the mapped drives because QuickBooks 2006 & 2007 are designed work using the IP address and working over a mapped drive can slow things down. You mention "with Vista we found it necessary to have PC-2 logon to PC-1 as a user to access the folder", how are you having PC-2 login to PC-1?

Regards,

I'm having this exact problem with a fresh install of Vista. These are 2 new PC's both running Vista and Quickbooks 2007. Networking, file sharing, and everything works perfectly until you open a Quickbooks 2007 file located on PC2 from PC1. Once you close the file and try to open another the LAN/file browsing activity fails. I've reproduced this dozens of times and a fresh install of Vista was performed with Quickbooks with the same results. This problem was not observed in XP with Quickbooks 2006.

Same problem here, does someone have a fix for this? I spent 3 hours on a tech support call yesterday with someone who ended up telling me "You are running to many applications on your computer" which is a load of hooey.

We really need to figure out whats going on with this error. :(

-=Kevin

I cannot help you because I never received information to correct the problem. We have, unfortunately, been working around it. "PC2" (non-host computer) just never gets out of one set of books. Not much of a solution. I truly believe this is a "bug" between quickbooks and microsoft vista. Hopefully, once the QB tech's realize this is an issue affecting many they will fix it! Awaiting Help_Please!
Thanks!

I spent 2 hours with QB and they stated they did not think they could help. By the time I got off the phone, none of the databases could be accessed via Vista.

After reviewing the setup, the Vista could see companies. When I use the open company box, not the file open company it appears to work fine for opening one company after the other. However when I use the file open, I get the error message -6000, -83. We close QB and reopen and all works fine for awhile.

All the updates have been done on the server as well as the individual workstations. When I asked the technical supervisor for documentation, she said there was not to share, nor could they share the case notes. I finally got some of the error code documentation.

Any suggestions?

As I look through the forum I see other treads with this same issue, I have a sneaky suspicion that these are not isolated cases.

I am going to try and call their technical support one more time and see if I can escalate to a manager to see if we can find someone to at least acknowledge this problem.

Paying for technical support that gives me a flat out lie to get me off the phone is not indicative of a professional company, I know out sourcing support saves costs but we have now been down for a week on this issue and all I end up talking to are people in another country reading from a script.

Ok so I talked to a pretty technical support manager who gave me some ideas that I am going to try.

Worse comes to worse I will see if I get a packet trace and maybe some developer who reads this forum can look at it and figure out why the connection between the machines in dropping.

If memory serves there is a TCP reset flag that I was seeing in the capture that I wasn't able to explain so with some luck maybe that will be a smoking gun to what the issue is.

I have to say that Vista is really disappointing, we have used Quickbooks for years now with no real issues and now with Vista it seems like half the software vendors out there are going through hell over it's release.

I'll update this when I have a good trace.

I'm running QB2007 on Vista Business, and have no issues switching company files. I'm hosting the company files on a Windows Small Business Server (2003, R2) with the QB Database Manager installed.

Since you have a Windows Server in the mix, I'm going to suggest the following:

Install the Quickbooks Database Manager on the server. Download and install the R8 patch (http://sharedld.intuit.com/pub.... You will need to manually start the Quickbooks Database Manager service if you can't reboot the server once the patch is installed.

Configure a shared folder for your company file. I have mine shared at \servernamequickbooks. Assign permissions as required. I believe Change for the share and Modify for the file system should be sufficient.

Copy the company files to the server & configure the database manager.

On client workstations, map a drive to the new Quickbooks share and test.

The secret sauce in all of this is that none of us are running a "Server" product. The failure mode only happens when the company files are hosted on a Windows Vista machine and then XP workstation try to mount the files as a client.

We have our qb files on the server and are using data management portion setup and working. The XP are able to get from one company to another, just the xp, the latest is the tech wants us to click the multiuser box off and on and see if that works on the vista.

Close QuickBooks.


Click the Windows Start button, click Settings, and then click Control Panel.


Double-click Add or Remove Programs.


Locate your QuickBooks installation and click to select it.


Click Change/Remove.


Click Next in the QuickBooks Installation window.


Click Repair, click Next, and then click Repair.


Once the repair has completed, click Finish.

You don't need to re-register after repairing your QuickBooks installation.

If you are still having problems you can use Reboot.bat to register all the QuickBooks .dll files.

From the QuickBooks installation directory C:/Program Files/Intuit/QuickBooks 2007, locate Reboot.bat.


Double click on the file Reboot.bat to register all of the QuickBooks .dll files.


Open QuickBooks to see if the issue is resolved

I have done this and it still does not work on the Vista on a consistent basis. What next

I have not tried this yet since I am off site, but if someone else wants to give it a go, I say go for it.

So here is the idea:

When the XP tried to open the folder on the remote machine the application hangs and comes back with the error, what is interesting to me is why does it happen at this point if all the machine is doing is opening a file sharing connection to the other machine.

My theory is that not only is it doing this, but its also opening a connection to the database manager on the Vista machine at the same time, I did a network trace and I believe I saw a bunch of traffic that was destined for the database manager.

If that is true, then my guess is that the database manager is having a problem and either not responding, or responding with corrupt information causing my machine to time out. I believe that this meta information from the database manager is the possible problem and its just manifesting as a windows file sharing problem.

I am going to disable that UAM (Unified Access Manager) on the Windows Vista PC for the Databaseuser17 account. This is the service account that the database manager uses to do whatever it is that its doing. There could be a problem where the server account needs admin access and since its running as a service is unable to prompt through the UAM and gain access.

So I am going to disable UAM on this account and see what happens.

I just thought I would throw out there that I am hosting the file on a Vista machine and it is another Vista machine that is trying to access the file. Maybe our problems will mysteriously disappear with the next QB update? It doesn't hurt to wish.

We are also having this problem after switch to a computer runningg vista. we had no problems running under windows XP. we are using a 3 user setup. one using xp the other 2 using vista. the problem happens when switching company files it doesn't always happen but it happens almost once or more every day and then we have to reset all the computers. also it seems to happen over night because each morning I have to reset all the computers to access the company files. again this was never a problem when we used Windows XP. but now with vista it been nothing but a nightmare.

tech support needs to fix this problem and stop charging it's customers for tech support they are not getting. we paid alot of money for this program and 3 user license to have it crash all of the time.

Has there been any progress on this? I'm also having the same issue where I'm running database manager (QB2007) on vista and clients being xp. I noticed that the issue occurs when I close quickbooks or open another company. Once I close it, something happens and my mapped network drive freezes up. I have to reboot the server and then it works. I can access it seemlessly again but the issue crops up again when I close. I think there is a conflict between the database manager and the OS. Please help.