How do I count the users in a database?

[Jeff Stroope]

Hi,

I have a secured Access db with about 6 users, each with their own login
credentials.

How can I count how many users are in the database to determine whether or
not to take a particular action when a form closes? In other words,

If #users > 1 Then Do this Else Do that.

 

[JString]

There's probably a much better way to do this but incase you don't get any
other help, it's at least possible to create a table that stores the names of
active users which you could then use to count the number of active users.

CurrentUser will return the user's name, and a name table would be better
than a global counter because a counter would eventually lose the correct
count when somebody crashes before the front end can modify the counter's
value. If you use a name table, the problem could be easily corrected once
that user logs back on.

 

[banem2]

Hi,

I have a secured Access db with about 6 users, each with their own login
credentials.

How can I count how many users are in the database to determine whether or
not to take a particular action when a form closes?  In other words,

If #users > 1 Then Do this Else Do that.

Check this, looks like the solution for your problem:

http://support.microsoft.com/kb/198755/EN-US/

Regards,
Branislav Mihaljev
Microsoft Access MVP

 

[Jeff Stroope]

Thanks JString - that's exactly what I'm going to do. It's so simple...how
come I didn't think of it?

 

[Douglas J. Steele]

Before you go to that exteme, see whether
http://support.microsoft.com/kb/285822/ meets your needs.

 

[mcnews]

Check this, looks like the solution for your problem:

http://support.microsoft.com/kb/198755/EN-US/

the code in the link works, but it listed me 3 times (3 rows).

 

[mcnews]

Before you go to that exteme, see whetherhttp://support.microsoft.com/kb/285822/meets your needs.

this solution list one row per user and uses less code.

 

[David W. Fenton]

:

the code in the link works, but it listed me 3 times (3 rows).

Do you have three connections open?

You might want to try the ldbusr.dll method, implemented in this
sample db (along with UserRoster, as well):

http://dfenton.com/DFA/download/Access/WhosOnADO.zip

 

[Tony Toews [MVP]]

How can I count how many users are in the database to determine whether or
not to take a particular action when a form closes? In other words,

Just curious. Why do you want to do this?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[banem2]

I have found something which might help. Have a look at
http://www.groupacg.com/ACGFree.htm, click on "Who's logged on for
Access 97 (30K)".

Regards,
Branislav Mihaljev
Microsoft Access MVP