Used security wizard but no logon prompt?

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

Guest

Access 2000

I have used the Security Wizard for the first time and have set up three
users with me as the Administrator and the other two as members of the User
Group. However, when I open the newly secured mdb I am not prompted to logon
and when I view the User and Group permissions and User and Group Accounts I
don't see the names of the users I created with the wizard so it seems the
wizard hasn't actually done anything.

The User and Group Accounts is very confusing e.g. in the Users tab only the
name Admin appears in the User dropdown at the top - why don't Users appear
as well? Also under 'Group Membership - Available Groups' both Admins and
Users appear and they both appear in 'Member Of.

The security concept is simple enough but it seems to have me foxed at the
moment!

Grateful for any help.
 
Keith

Thank you for the helpful links. However, they do seem to confirm that
securing a database is not as simple as using the Security Wizard but is a
complex and tedious business. I can't believe it should be as difficult as
the MS KB article and your notes suggest or am I missing a trick?
 
Hi.
Access 2000

I have used the Security Wizard for the first time and have set up three
users with me as the Administrator and the other two as members of the User
Group.
Click to expand...

Don't use the Security Wizard in Access 2K. It leaves several gaping holes
when securing the database. Please see Joan Wild's (Access MVP)
step-by-step advice for securing both Access 97 and 2K databases on the
following Web page:

http://www.jmwild.com/security97.htm
However, when I open the newly secured mdb I am not prompted to logon
and when I view the User and Group permissions and User and Group Accounts I
don't see the names of the users I created with the wizard so it seems the
wizard hasn't actually done anything.
Click to expand...

You are still joined to the default workgroup, not your secure workgroup.
It's easiest to create a shortcut that joins you to the secure workgroup
only when opening the secured database. Please see the tip "How to open
databases and only be prompted for User ID and password for the secure
databases" for instructions on how to create this shortcut on the following
Web page:

http://www.Access.QBuilt.com/html/security.html
The User and Group Accounts is very confusing e.g. in the Users tab only the
name Admin appears in the User dropdown at the top - why don't Users appear
as well? Also under 'Group Membership - Available Groups' both Admins and
Users appear and they both appear in 'Member Of.
Click to expand...

Since you are joined to the default workgroup, you are looking at the
permissions assigned to the database from the default workgroup, which has
only one user, the default Admin user, but no other users.
The security concept is simple enough
Click to expand...

Most of us would disagree with you. User-level security is not simple. And
it's not enough.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Whether "complex and tedious" are the correct words is subject to
debate ;-) "Exacting" might also be appropriate. I recommend you do
not use the wizard, but do each step manually.

In addition to Keith's instructions, you can find links to several
others on the website in my signature. All of them are good... one
should suit your style.



Keith

Thank you for the helpful links. However, they do seem to confirm that
securing a database is not as simple as using the Security Wizard but is a
complex and tedious business. I can't believe it should be as difficult as
the MS KB article and your notes suggest or am I missing a trick?
Click to expand...


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