Setting up security level

  • Thread starter Thread starter Lynn Trapp
  • Start date Start date
Hi. I have created a database that resides on the network
drive. From my computer I set up different users using
Access security wizard. As user names I used the same
network ID names the people use when they login in the
morning. It works fine from my computer. It is asking
for a paswword and gives me proper permissions depends on
the user name I have entered. However, when I try to open
a file from somebody elses computer it opens just fine
without any password request. The reason, I suspect, is
that by default everyone is login in as Admin and not with
network ID. Is there way to change this setting for this
Access file only?
Thank you for your help.
 
The others need to join the workgroup where your security was set up.

If you follow the proper security instructions, your users should not be
able to open your database unless they are joined to the proper workgroup
file. You could also include the workgroup in the shortcut so that anytime
they open the databsae (using the shortcut) it would do so with the
workgroup.

Rick


Hi. I have created a database that resides on the network
drive. From my computer I set up different users using
Access security wizard. As user names I used the same
network ID names the people use when they login in the
morning. It works fine from my computer. It is asking
for a paswword and gives me proper permissions depends on
the user name I have entered. However, when I try to open
a file from somebody elses computer it opens just fine
without any password request. The reason, I suspect, is
that by default everyone is login in as Admin and not with
network ID. Is there way to change this setting for this
Access file only?
Thank you for your help.
 
Rick, what does it mean "The others need to join the
workgroup where your security was set up." They should do
it from their computers? I am new at this, please
elaborate a little more. Thanks.
 
In order to open the fiel and use the security that you built, the users
would need to 'join' the workgroup. This is done by opening the
MSWorkGroupAdministrator application. It lives in the MS Office folder.
The file name is WRKGADM.EXE

If you open that program, it will give you an option to 'join' a workgroup.
Oce you have done this, that workgroup is used for every Access file you
open. It would require the user to sign on each time they open an Access
file.

If you wnat them to be able to use their default workgroup for all their
personal files, but you would like to force your database to open with the
appropriate workgroup, then you can change the shortcut to include the
workgroup. The target would look something like...

"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"C:\MDB\SomeDatabaseName.mdb" /wrkgrp "\\Server1\MDB\SECURE.mdw"


Now...

You seem to have a bigger problem. If it is not asking your users to log
on, but they are still able to access your database and get to the data,
then you have not secured your database properly. All of the above is
worthless if a savy Access user rejoins the default workgroup on his
computer and opens your database without signing on.

MAKE A COPY of you r database before you secure it. It is very easy to
screw up!!

There is a "Security FAQ" on the Microsoft website that talks about how to
secure your database. Basically, it links your database to a particular
workgroup. The other key is that it instructs you to take away access from
the 'users' group and to make userid "admin" a member of the user group.
This means that anyone signing on with a default workgroup would not be able
to use it because they would sign on with "admin".

I maintain a database that I secured three years ago and have not messed
with security much since then. After reading the FAQ, post a new message if
you need further help.

Hope this gets you on the right path.

I'm sure some MVPs will have more to add if I am unclear here.

Rick

Rick, what does it mean "The others need to join the
workgroup where your security was set up." They should do
it from their computers? I am new at this, please
elaborate a little more. Thanks.
 
Back
Top