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

Rabu, 13 Januari 2016

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

Hi Sarah

I'm not sure I understand. You use the roster while in the back end, not the front end. When a user opens his local copy of the front end a connection is made to the back end and he should show up in the roster.

-Bill

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

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?

Thanks

Sarah

---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.

-Bill

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

Bill,

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?

Sarah

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

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

Bill

---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

Sarah

__._,_.___