Workgroup Admin from XP Runtime?

  • Thread starter Thread starter Skeeboe
  • Start date Start date
S

Skeeboe

How can you get to Workgroup Admin from the 2002 (XP) Runtime? There
is no Tools>Security>Workgroup Administrator. Is there an exe file or
can I just change a registry key? Thanks in advance!
 
Try finding the file "wrkgadm.exe" in your computer.

OTOH, if the run-time application is implemented with
Access Security, it should generally use a "custom" MDW
file and not the "default" MDW file on the PC.

HTH
Van T. Dinh
MVP (Access)
 
No, there's no wrkgadm.exe file installed with the access 2002 runtime
client. I am using a custom mdw which is why i need people who install
my program to be able to join the correct workgroup. Any other ideas?
 
Skeeboe said:
No, there's no wrkgadm.exe file installed with the access 2002 runtime
client. I am using a custom mdw which is why i need people who install
my program to be able to join the correct workgroup. Any other ideas?
Click to expand...

1)
You should be able to include your workgroup file as a command line
argument in a custom shortcut which would eliminate the need for them to
join your mdw file. That is the preferred way to do it anyway as it won't
mess with other Access usage on their PC.

2)
Access 97's ODE allowed you to distribute the workgroup admin tool as part
of your install package. Does the version you're using not allow this?
 
1. I'm familiar with that process and I may have to end up doing that,
I'd prefer no to though

2. Access 97 and 2000 used a wrkgadm.exe file which joined the
workgroups and was a part of the install package. But with Access 2002
and 2003 they integrated it into the TOOLS>Database
Utilities>Workgroup Admin menu. The problem with access runtime is I
can't seem to get the TOOLS menu to be visible!
 
Since you are using the runtime, then no you doubt you have created a number
of custom tool bars (you have to least create one!).

So, can you copy/create your own menu? I would think that taking the menu
options (copy, don't move!) from the built in menu bar where the security
options are, and copying that to your own menu should do the trick.

Note that you do NOT get the User and group accounts, and the User and group
Permissions in the runtime. (you did not get those in previous versions
either).

So, the solution for creating new users, and new accounts is simply to spend
an afternoon and write your own code to accomplish this.

I wrote my own. You can see the screen shots at:

http://www.attcanada.net/~kallal.msn/Articles/UseAbility/UserFriendly.htm

The above is only two VERY small screens you have to make (a few hours at
most). So, take a look at the above to get some ideas.

I just spent 5 minutes, created a mdb with a form that says "hello". I also
crated a custom menu bar (another 30 seconds, and just grabbed the workgroup
menu option). I then crated a mde (another 10 seconds!). I then created a
shortcut with the /runtime switch. The users and group permissions, and the
users and group accounts DOES NOT WORK (as I expected, but I did want to try
this, as those options are in a2002).

However, the workgroup admin DOES work fine!. So, trying this with the
runtime switch does seem work. So, you can use the built in workgroup admin,
and that will save you having to install/run/setup the old wrkgrp.exe like
we used to. This seems a lot better!
 
DoCmd.RunCommand acCmdWorkgroupAdministrator

A lot of companies are still using the 2000 runtime so I couldn't
incorperate it into my program. So I just created a db that runs that
command when opened, made a MDE from 2002 Dev. Ed. Now when the
customer runs my program I check to see if they are running 2002 and
need to join my workgroup, I just call the new db. Thanks for the
help!
 
Back
Top