Limits on number of concurrent users in Access 2007

[Perceptus]

I am developing a Webservice (WSDL) that uses an access 2007 database. The database specifications on msdn say a limit of 255 concurrent users. What happens when you attempt to exceed this limit? I haven't figured out a way to test for this condition.

[RuralGuy]

Since 255 is a real familiar number, I suspect only a byte has been reserved for keeping track of the concurrent users (just a guess). If true then Access will probably *not* allow the 256th user into the system. With that many potential concurrent users you should really be looking at SQL server anyway.

[Perceptus]

Sadly SQL is not an option. Even if a byte was used to track the number of concurrent users, you wouldn't be able to see the number of users connected without connecting to the database object( i think ).

[orange]

Tell us more about your web service and WSDL - there is very little info for this and Access/vba.
Any code you have that is working would be good in the Sample Databases or Code Repository areas of the forum.

[Perceptus]

Will do. I will post my notes/information in the Code Repo.

[orange]

Good stuff!