How do I add a new user to an existing workgroup?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I apologize for asking such an obvious question but I am very new to securing
and maintaining a secured database.

I have used the wizard to secure a database that I created prior to
distributing for others to use. The db and workgroup information is stored on
a shared server and users access the db by a shortcut on their desktop. This
is working beautifully...too beautifully infact...because now other people
would like inquiry access. My problem is that I cannot figure out how to add
new users to the existing workgroup. I have tried to accomplish this through
the Secured WorkGroup db as well as through the shortcut on my desk top. The
only option I can think of that I havent tried is opening the shortcut
exclusively.

Any direction would be greatly appreciated.

Thank you,

Nicole
 
The shortcut probably uses the /wrkgrp switch to ensure that when the
user logs on, the database uses the correct secured workgroup file. (It
certainly should do that. And if it /doesn't/, the shortcut actually
should not work.)

So, all you need to do is to log on, using that shortcut, but using the
username & password of a member of the Admins group of that secured
workgroup file.

Then you can use the normal security UI options to add & delete users &
groups, add & delete users to & from groups, & so on.

If you have "locked down" your database by removing all the normal menu
options including the security ones, you'll need to code some way of
making those options available agin, when the current user is a member
of the Admins group - so that he can use those options.

Alternatively, it's possible to write a form through which you can do
all the security functions. Then, the form is a standard part of your
system, but only members of the Admins group can open it.

HTH,
TC
 
Thank you so much. I am going to create a form to perform the security
functions. What a great idea! Currently the only way I can access the tools
menu is to press shift when I open the db shortcut. Didn't even think of that
until I read your response.

Thanks for the information!

Have a great day,

Nicole
 
No probs, glad it helped.

You'll need to learn the relevant VBA code, eg. CreateUser, CreateGroup
(from memory; I don't have Access here to check).

HTH,
TC
 
Back
Top