Find Out Who Has Joined Workgroup

[RH610]

Access2000 -

The .mdw file is on a network server. Users join from the workstations. I can print out a list of who is in the .mdw file, but is that the same as which PCs have JOINED the workgroup? Is there a way to find out who has "joined" other than going to each PC and seeing if it asks for a password?

It seems that some users got out of the workgroup. Are there ways for a user to become "unjoined" from a workgroup?

Thank You

 

[RickSpr]

When you join a workgroup using the Workgroup Administrator program, all it really does is change a registry key that indicates the default .mdw file to be used when the user starts Access.

In general, the contents of the .ldb file are not reliably coordinated with any workgroup file, so that won't help you.

To determine whether a given user is joined to a workgroup, you could start Access and see if they get a logon prompt, as you say, though that really isn't conclusive. They could potentially be joined to another secured workgroup, rather than the one you're assuming.

A better way would be to start the Workgroup Administrator. It shows the current workgroup file in its initial dialog.

From VBA code, you can look up the registry key on a user's computer to determine the current workgroup. However, you would only be able to do so on that particular computer.

If it's any help, you can create a simple database with just enough code to report the value of SysCmd(acSysCmdGetWorkgroupFile) in a message box. You could distribute this database as a little utility, or run it from the network, and have the user report their current workgroup to you that way.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[psemianonymous]

I'd recommend you steer away from using the Workgroup Administrator to join all your users to a non-default workgroup. Instead, use a shortcut for your application that specifically opens your database with your custom workgroup file, and tell your users to only access the database using the special shortcut.

You may have a special setup where it's actually beneficial to join everyone to the same custom workgroup file, but I don't think that's the case.

 

[PROXI]

if you decide to go with the shortcut theor that foolio laid out then a post that you might want to see is this:

thread702-676860 has a very nice user tracking code in it. As well as how to insert it into a form.