Distribute without .mdw?

[Kevin K. Sullivan]

I have implemented the user-level security wizard in Access XP on my
database. Things are peachy in that --

- Only I can make design changes using my custom.mdw and my account.
- Admin has been removed from the Admins group and added to the Full Data
Users group

If Admin's password is cleared, anyone opening the file *using custom.mdw*
is automatically logged in as Admin with the appropriate (restricted)
priviledges.
Anyone opening the file *not using custom.mdw* gets the "You do not have the
necessary permissions..." dialog.

Is it possible to change permissions so that people without custom.mdw can
still get in as Full Data Users? I would like to make distribution as easy
as possible -- I would like to avoid distribution of .mdws, creating
shortcuts with /wrkgrp, etc.

TIA,

Kevin

 

[Jack MacDonald]

When the user starts Access without the custom.mdw file, then Access
knows nothing at all about your Full Data Users group. You must let it
know *something* before it will work. The only two things in common
between your custom.mdw and the default mdw are the Admin user and the
Users group.

You must grant the permissions either to the Admin user or to the
Users group before the Admin user will work under your conditions.

I have implemented the user-level security wizard in Access XP on my
database. Things are peachy in that --

- Only I can make design changes using my custom.mdw and my account.
- Admin has been removed from the Admins group and added to the Full Data
Users group

If Admin's password is cleared, anyone opening the file *using custom.mdw*
is automatically logged in as Admin with the appropriate (restricted)
priviledges.
Anyone opening the file *not using custom.mdw* gets the "You do not have the
necessary permissions..." dialog.

Is it possible to change permissions so that people without custom.mdw can
still get in as Full Data Users? I would like to make distribution as easy
as possible -- I would like to avoid distribution of .mdws, creating
shortcuts with /wrkgrp, etc.

TIA,

Kevin

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

 

[Joan Wild]

When you ran the wizard, you shouldn't have chosen any of the built in
groups. Instead you should have chosen the option to grant permissions to
the Users group.

What you can do now is, whatever permissions are applied to 'Full Data
Users', give the same permissions to the Users Group.

 

[Kevin K. Sullivan]

Thank you so much for your responses, Joan and Jack.

I've coaxed my database into compliance by granting the permissions that I
want to be universal to the Users Group. I realize now that any 'Full Data
Users' group permissions rely on the custom.mdw, which I don't want to
distribute. Joan, thanks for giving me both the "what to do from the
beginning" instructions and the "what to do now" instructions.

Kevin