Number of Concurrent Users/Connections Available?

[Guest]

Hello

Perhaps this question comes from my lack of experience with Access, but is there any way to know, or at least count the number of users accessing a particular Access database that is being accessed using the Jet database engine libraries from a Visual Basic application

In other words, are there any queries I can issue to the Jet engine to obtain the number of concurrent users, or alternatively, the number of concurrent connections

Thanks for any help you can give me

John

 

[Tony]

Hey John,

Open the .ldb file and that will tell you how many users
are accessing the file.

Tony

-----Original Message-----
Hello,

Perhaps this question comes from my lack of experience

with Access, but is there any way to know, or at least
count the number of users accessing a particular Access
database that is being accessed using the Jet database
engine libraries from a Visual Basic application?

In other words, are there any queries I can issue to the

Jet engine to obtain the number of concurrent users, or
alternatively, the number of concurrent connections?

 

[Dirk Goldgar]

Hey John,

Open the .ldb file and that will tell you how many users
are accessing the file.

Tony


with Access, but is there any way to know, or at least
count the number of users accessing a particular Access
database that is being accessed using the Jet database
engine libraries from a Visual Basic application?
Jet engine to obtain the number of concurrent users, or
alternatively, the number of concurrent connections?

Not readily, because the database engine doesn't clear the slots that
were created for users, after the users have logged out. It just reuses
them as needed, until the last user logs out and the .ldb file is
deleted.

John, you can use ADO to extract the Jet UserRoster, as described here:

http://support.microsoft.com/?id=198755

 

[Guest]

Great! Thanks a bunch!

John