Was wondering if we could change the amount of connections to access

Luckydvl

Registered User.
Local time
Today, 08:07
Joined
Oct 6, 2004
Messages
11
we have a database at work that is being runned on a server machine running windows 2000, the problem that we have is we have 11 machines that connect to the database on the windows 2000 machine. when we get to the 12 user it says to many connections open, so now one of the computers have to log off to log in. is there anyway to change the amount of user loged on to the database. or is it a windows 2000 issue or a access issue. we are planning to expand to 3 more machines but wont be able to have all the machines logged on thx for any advice ahead of time
 
This will create more overhead but it can work. I've setup databases that basically copy over the data the user needs into a local table for them to view. This way the connection is only open briefly to pull the data. But you need to write code to write the changes back to the source. Like I said a lot of overhead but I've had over 100 people using the same database using this method without any problems.
 
well i was hoping for a simpler solution. i do notice on windows 2000 there is limit to the amount of user connected to a shared folder 10 to be exact. could that be the reason why since only ten people log on to the same shared folder cause they way we have it set up is the main database is on that machine and then we share the database. all we do is copy a short cut and put them on the other machines to access the database. i know this way maybe wrong but that is the way they have been running it. i was the unlucky one to take over this database i wasnt the one who created it.
 
I'm sure that is the problem. I know access gets bogged down the more users are connected but it doesn't prevent more users after a certain point unless you want to call crashing preventing...
 
Luckydvl said:
well i was hoping for a simpler solution. i do notice on windows 2000 there is limit to the amount of user connected to a shared folder 10 to be exact. could that be the reason why since only ten people log on to the same shared folder cause they way we have it set up is the main database is on that machine and then we share the database. all we do is copy a short cut and put them on the other machines to access the database. i know this way maybe wrong but that is the way they have been running it. i was the unlucky one to take over this database i wasnt the one who created it.
If you're using Win2k Pro in a peer to peer network, the 10 user limit on shared folders is going to be your problem. If you moved the database to a proper file server this problem doesn't exist.
 
If you split the db and place the fe on each user's local drive and leave just the be on the share, you can probably get past the problem. With only the data on the shared drive, I think the only time the connection would be active would be when someone was actually retrieving or updating data.

In any event, splitting the db won't make the problem worse and is good technique.
 

Users who are viewing this thread

Back
Top Bottom