Access Security

29 May 2006 2:11 AM

New TO Access

For the first time i have devloped a multi user application that required
user level security. This is fine for this application but now I find that
the same security applies to all my access applications most of which are for
my own use and don't need security.

I have tried the help solution which was to give all users all permissions,
create a new database etc etc.

When I did this I lost the security on the multi user application and had to
restore my security files from a back-up.

Even If I create a new database, security applies.

How can I just have the security settings apply to the one application and
not everything I do in Acccess?

David

29 May 2006 12:11 PM

Rick Brandt

New TO Access wrote:
Show quoteHide quote

> For the first time i have devloped a multi user application that
> required user level security. This is fine for this application but
> now I find that the same security applies to all my access
> applications most of which are for my own use and don't need security.
>
> I have tried the help solution which was to give all users all
> permissions, create a new database etc etc.
>
> When I did this I lost the security on the multi user application and
> had to restore my security files from a back-up.
>
> Even If I create a new database, security applies.
>
> How can I just have the security settings apply to the one
> application and not everything I do in Acccess?
>
> David

You need to read up on how Access security works. In Access whether you are
prompted to log in is controlled by the workgroup file you are using (MDW), NOT
the MDB file you might choose to open.

If the workgroup being used has a password on the default user "Admin" then you
are prompted to log in. If that user does not have a password then you are not
prompted. If you make a workgroup that requires a login prompt your default
workgroup then you will be prompted to login every time you open Access.

When you run the security wizard you go through a step to create a new workgroup
file and you are given the option to make that new workgroup your default. You
should have NOT used that option, but instead used the option to create a custom
shortcut for opening your secure file.

A custom shortcut can open Access, specify the file to open, and specify the use
of a workgroup file that is not your default workgroup. Using such a shortcut
is how you can be prompted only when opening secured files while not being
prompted for others.

Access security is HARD to understand without really digging into it. Just
using the help file and the wizard is almost certain to end up with security
that is wrong. If you Google this group you will find links to more than one
explicit step by step instructions for setting up security. One of these is
your best chance to get it right.

For now you need to go into the workgroup administrator utility and rejoin the
default workgroup (System.mdw). That will eliminate all of the login prompts.
Then you need to delete your first attampts at security (MDB and MDW), find one
of the step by step instruction guides, and start over.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com