too many concurrent users

[Roni Sutton]

We are getting this message in a database that is being used by 75 users. Basically, we partially replicated the database so that small groups of no larger than 10 users are in each replica at a time. However, the replicas and the design master open recordsets to a third database which is what we are getting the error on. When the error pops up, if you debug, you end up on the line that opens the recordset. There are huge amounts of code in this db but I have tried to go through it to be sure that there is nowhere in the code that opens the recordset and doesn't subsequently close it. At no time is the recordset open very long. In all cases that we open the recordset, we check something in it and then immediately close it. Any ideas? Please help, we are about to be lynched.

Thanks, Roni

 

[bob makepeace]

Hi,

Access 97 should allow up to 255
concurrent users. eg. we have a database
with 200+ users.

One thing you might check is the use
of dlookup etc which opens up a
connection every time it does a lookup.

hope this helps

 

[AndrewS]

Hi There, Mine is a request rather than a solution so tell me to get outahere if you want to, but hey I ned some help here.
I have a rather small DB compared to yours and I am having trouble getting multiple users to use the system.
When a second person tries to use the system, I get error messages, like "there was a problem executing this command"
or " the database is open and in use by (lists persons name)"
Yes I'm pretty new at this, and this has me stumped.