Rabu, 13 Januari 2016

[MS_AccessPros] Re: Count Number of User that have backend open. update


Hi Bill,

For now I am not opening the ' frmInactiveShutDown' form. 
Anyway I am more interested in seeing who is logged in and being able to automatically log them out and that 
is working. This is a huge help.

However, the User Roster does not list all users, unless they are using the same .mde . If another user is using the same mde to open the backend, then the user is listed. However, when I send the logout request message, all the users are getting the message and are all being closed out, even if they are not listed in the roster. I guess the timer triggers when the adminmessage table changes.

When I distribute the application, each user has to have their own mde.
I can use it the way it is,  just wondering why it dos not list all the users in the user roster?



---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :

Hi Sarah

I'll take a look as soon as I can. I'm very busy at work this week. Try setting it to a shorter time like 10 minutes to see if that works.


---In MS_Access_Professionals@yahoogroups.com, <sarahk@...> wrote :

I love the ShowUserRoster utility. But I am having one problem with it, even though I changed the 'intMinutesUntilShutDown = 720' (720/60= 12hours!!!) in the inactive shutdown form, the message triggers after a very short time and the application closes.
What am I doing wrong?

---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :

Rats! I forgot to include the original post in my first reply. ...Sorry!


---In MS_Access_Professionals@yahoogroups.com, <sarahk@...> wrote :

I have a split database : shared backend on a network and every user has their own front end.

Is there a way to count the number of users that currently have the backend open?

I am using Access 2003.

Thanks for your help




Posted by: sarahk@schemesoftware.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (12)



Tidak ada komentar:

Posting Komentar