| Author |
Message |
tcs@mvn.net
Guest
|
Posted:
Thu Oct 27, 2005 12:03 am Post subject:
Multi user Corruption |
|
|
I have 2 user system, and a large datafile (50 meg+) that as histories
for gas customers. The updates and customer view is slow on the second
system. The data sgets corrupted quit aften and I must rebuild. Any
sugestions or fixex?
John
|
|
| Back to top |
|
 |
Greg
Guest
|
Posted:
Thu Oct 27, 2005 12:03 am Post subject:
Re: Multi user Corruption |
|
|
On 26 Oct 2005 14:07:39 -0700, "tcs@mvn.net" <tcs@mvn.net> wrote:
| Quote: | I have 2 user system, and a large datafile (50 meg+) that as histories
for gas customers. The updates and customer view is slow on the second
system. The data sgets corrupted quit aften and I must rebuild. Any
sugestions or fixex?
John
We had a similar problem and found the defragging the hard drive of |
the host computer stopped it. I also deleted a lot of unnecessary
files from the host PC, then defragged the rest of the computers that
are on the network. The problem has now all but disappeared.
Greg |
|
| Back to top |
|
 |
Golden California Girls
Guest
|
Posted:
Thu Oct 27, 2005 8:03 am Post subject:
Re: Multi user Corruption |
|
|
Greg wrote:
| Quote: | On 26 Oct 2005 14:07:39 -0700, "tcs@mvn.net" <tcs@mvn.net> wrote:
I have 2 user system, and a large datafile (50 meg+) that as histories
for gas customers. The updates and customer view is slow on the second
system. The data sgets corrupted quit aften and I must rebuild. Any
sugestions or fixex?
John
We had a similar problem and found the defragging the hard drive of
the host computer stopped it. I also deleted a lot of unnecessary
files from the host PC, then defragged the rest of the computers that
are on the network. The problem has now all but disappeared.
|
But is the keyword. As long as you run QB on a peer to peer network you
will have corruption problems. If you don't want to say But you have to
run it in client server mode, and that means another computer running
windows terminal services and a five user license pack.
The best you can do in peer to peer is get two matched fast computers, buy
the highest quality network cable you can find, put them on their own high
quality hub so as to minimize the data path between the machines. It's the
best you can do for the problem, but [there is that word] you will be
rebuilding the file from time to time, no matter what.
|
|
| Back to top |
|
 |
Mike Schumann
Guest
|
Posted:
Thu Oct 27, 2005 4:01 pm Post subject:
Re: Multi user Corruption |
|
|
Terminal Server is definitely the way to go to solve both your corruption
and performance problems. If you don't want to do that, at the very least,
make sure that you have UPSs on all of your computers and networking gear.
Mike Schumann
"Golden California Girls" <gldncagrls@aol.com.mil> wrote in message
news:43605684.78C5FF85@aol.com.mil...
| Quote: | Greg wrote:
On 26 Oct 2005 14:07:39 -0700, "tcs@mvn.net" <tcs@mvn.net> wrote:
I have 2 user system, and a large datafile (50 meg+) that as histories
for gas customers. The updates and customer view is slow on the second
system. The data sgets corrupted quit aften and I must rebuild. Any
sugestions or fixex?
John
We had a similar problem and found the defragging the hard drive of
the host computer stopped it. I also deleted a lot of unnecessary
files from the host PC, then defragged the rest of the computers that
are on the network. The problem has now all but disappeared.
But is the keyword. As long as you run QB on a peer to peer network you
will have corruption problems. If you don't want to say But you have to
run it in client server mode, and that means another computer running
windows terminal services and a five user license pack.
The best you can do in peer to peer is get two matched fast computers, buy
the highest quality network cable you can find, put them on their own high
quality hub so as to minimize the data path between the machines. It's
the
best you can do for the problem, but [there is that word] you will be
rebuilding the file from time to time, no matter what.
|
|
|
| Back to top |
|
 |
Greg
Guest
|
Posted:
Fri Oct 28, 2005 8:02 am Post subject:
Re: Multi user Corruption |
|
|
On Wed, 26 Oct 2005 21:24:52 -0700, Golden California Girls
<gldncagrls@aol.com.mil> wrote:
| Quote: | Greg wrote:
On 26 Oct 2005 14:07:39 -0700, "tcs@mvn.net" <tcs@mvn.net> wrote:
I have 2 user system, and a large datafile (50 meg+) that as histories
for gas customers. The updates and customer view is slow on the second
system. The data sgets corrupted quit aften and I must rebuild. Any
sugestions or fixex?
John
We had a similar problem and found the defragging the hard drive of
the host computer stopped it. I also deleted a lot of unnecessary
files from the host PC, then defragged the rest of the computers that
are on the network. The problem has now all but disappeared.
But is the keyword. As long as you run QB on a peer to peer network you
will have corruption problems. If you don't want to say But you have to
run it in client server mode, and that means another computer running
windows terminal services and a five user license pack.
The best you can do in peer to peer is get two matched fast computers, buy
the highest quality network cable you can find, put them on their own high
quality hub so as to minimize the data path between the machines. It's the
best you can do for the problem, but [there is that word] you will be
rebuilding the file from time to time, no matter what.
So in the words of a famous Australian, "please explain"? |
We have five computers all using qb 2005/2006. One holds the data file
and all the rest link to that data file.
Could you either point me to a link to set it up for windows terminal
server or explain gently on whats required.
Greg |
|
| Back to top |
|
 |
Golden California Girls
Guest
|
Posted:
Fri Oct 28, 2005 1:04 pm Post subject:
Re: Multi user Corruption |
|
|
Greg wrote:
| Quote: | On Wed, 26 Oct 2005 21:24:52 -0700, Golden California Girls
gldncagrls@aol.com.mil> wrote:
So in the words of a famous Australian, "please explain"?
We have five computers all using qb 2005/2006. One holds the data file
and all the rest link to that data file.
Could you either point me to a link to set it up for windows terminal
server or explain gently on whats required.
Greg
|
Okay. This is an overview of what we are talking about.
http://www.microsoft.com/windows2000/server/evaluation/business/terminal.asp
You need a dedicated fast computer to run the Windows 2000 server. You have to
install a five user license pack for Quickbooks on this computer. No it can't
be five indivdual licenses, it has to the the five user pack. There are some
tricks to getting this installed right, use google to check past threads here,
read the QB FAQ's, and don't be afraid to call QB support for your install. QB
is not installed on the user computers at all!
Your users open a terminal service session on the server and run QB. As the
only data going between them and the server is the keyboard, mouse and screen,
it is incredibly faster that the multi megabytes that QB sends in a peer to
peer configuration.
If you have a resonably smart IT type, he sould be able to tune the disc cache
and system parameters to speed up QB even further on the server system. |
|
| Back to top |
|
 |
Mike Schumann
Guest
|
Posted:
Sat Oct 29, 2005 12:02 am Post subject:
Re: Multi user Corruption |
|
|
Terminal Server is also standard in Windows 2003 Server (regular edition,
not Small Business).
Mike Schumann
"Golden California Girls" <gldncagrls@aol.com.mil> wrote in message
news:4361DB93.1D50F1BA@aol.com.mil...
| Quote: | Greg wrote:
On Wed, 26 Oct 2005 21:24:52 -0700, Golden California Girls
gldncagrls@aol.com.mil> wrote:
So in the words of a famous Australian, "please explain"?
We have five computers all using qb 2005/2006. One holds the data file
and all the rest link to that data file.
Could you either point me to a link to set it up for windows terminal
server or explain gently on whats required.
Greg
Okay. This is an overview of what we are talking about.
http://www.microsoft.com/windows2000/server/evaluation/business/terminal.asp
You need a dedicated fast computer to run the Windows 2000 server. You
have to
install a five user license pack for Quickbooks on this computer. No it
can't
be five indivdual licenses, it has to the the five user pack. There are
some
tricks to getting this installed right, use google to check past threads
here,
read the QB FAQ's, and don't be afraid to call QB support for your
install. QB
is not installed on the user computers at all!
Your users open a terminal service session on the server and run QB. As
the
only data going between them and the server is the keyboard, mouse and
screen,
it is incredibly faster that the multi megabytes that QB sends in a peer
to
peer configuration.
If you have a resonably smart IT type, he sould be able to tune the disc
cache
and system parameters to speed up QB even further on the server system.
|
|
|
| Back to top |
|
 |
|
|
|
|