Too many active users

[Guest]

Hello, We have few applications accessing a MS Access mdb to retrieve a query
data. When the number of calls sent to the mdb are more than a limit, we get
the error called "Too many active users" and all the extra calls are rejected.

Can anyone help me on this? Is there any solution where we can change
settings in MS Access to increase the size?

 

[Guest]

According to the specs, Access should be able to handle 255 users. The
reality is divide that number by 10 and you'll be closer to the truth.

How are you connecting to the database? It's possible that you could have
multiple connections per person if the VB app isn't written correctly.

Another possibility is to optimize the queries so that they run faster. That
way you'll have fewer active users.

If you truly do have hundreds of users, it may be time to upgrade to a more
industrial strength database.

 

[Guest]

Thanks Jerry. Yes, there are atleast 10 Excel-VBA applications that try to
query the access mdb. But all the applications have the same user id. Because
they are run by scheduled tasks on a windows 2000 server. Dont we have any
way to increase the number 255?

 

[Guest]

Not with an mdb file. You probably need to upgrade to SQL server if > 255 is
a requirement.

They might all have the same user ID; however, it's the number of
connections that counts.