QuickBooks Pro 2005 Access Problem

Mar 18, 2005 8 Replies

Hello to All -



Helping a friend with his printing business. 2 PCs connect over a peer-to-peer network that includes a file server. Each of the PCs has QB Pro 2005 Multiuser installed, and all company files are on the file server.



Either one of the PCs can individually open the company file with no problem. However, if the 2nd PC tries to open the company file while the 1st PC already has it opened, we get this error message:



Error: "The connection to the QuickBooks company file has been lost. Perhaps there has been a problem with the computer on which data file name resides."



The first PC still has the company file open and can work with it when this happens. Again, both PCs have multiuser access and we believe all user settings and etc. for multiuser access are correct.



Please help and thanks, John Murray


First thing I'd check is to see if the network drive has been mapped. Meaning are they accessing the file on the 3rd machine (server) as E:\myqbfile.qbw. Mapping is important to make QB happy.

You didn't state what kind of file sharing permissions are in place, each user and the server must be administrators and the server must be set to allow users to update files & all users equal full access.

snipped-for-privacy@MurrayComput> Hello to All -

You also do not say if you bought 2 QB licenses. You can install the same QB on several systems, though it is against your license agreement. However, you cannot access the same QB file at the same time when you do this.

Mike Block - QuickBooks Tax Cut C.P.A. Intuit paid me to make QuickBooks better!

formatting link
formatting link

The OP states that QB Pro 2005 Multiuser installed, that implies the purchase of the multi user edition which comes with a number of licenses.

My inclnination is for the OP the processor is being overloaded. i.e. it can handle one user on Quickbooks but the second user crashes the network.

One thing to try is moving the base file to the other computer on the peer to peer network.

Another solution if you've got excess money floating around is get a dedicated server. Multi user does work, it is only as good as your weakest link (in this case that maybe your processor on the base unit, the other stuff running on that CPU, or other factors.

MYOB has a list of stuff to check for network problems. Does Quickbooks have something similar?

To the last poster on this thread. You do realize Quickbooks sells packages that include three licenses to use the software in a multi user environment? Of course that doesn't necessarily mean the hardware you have won't be as S L O W A S F R O Z E N M O L L A S S E S I N W I N T E R.

Thank you for the help; the drive has been mapped, and is used for a variety of data storage needs, not just QB. We went through everything to be sure that file permissions, file attributes, QB user settings and QB version/updates all are correct, and we believe they are. It just baffles us that each machine individually can access the company file, but when the second tries to open the error occurs.

Hello Mike -

Sorry if I wasn't clear, we do have multi-user licenses, 5 in all; with only 2 machines actually running QuickBooks. Also, the error message would state if this were a licensing issue, but instead we get what I mentioned in my original post.

Hi DW --

Thanks for the help, we have not yet tried moving the company file to one of the clients, but did recreate everything on the data server. Our network really runs pretty well, we do sign printing which calls for really large, cpu intensive work and have no problems. Also, the 2 machines running QB do not participate in production work, so there isn't really a weak link in that regard.

Are you running a hub or a switch to connect? I have encountered problems on a hub that were resolved when changing to a switch.

MartyM

formatting link

Hello Marty -

Yes, we are using a switch to access the data server, and all other programs / all computers work correctly. Also, as mentioned, either of the QB computers can access and open the company file on the data server with no problems of any kind; it's only when the second QB computer tries to open the company file that we get this Error:

"The connection to the QuickBooks company file has been lost. Perhaps there has been a problem with the computer on which data file name resides."

This shows error code 6 as well.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required