Workgroup File Admin user account

3 May 2006 7:04 PM

Brian

As part of securing a database, it's important to add a password to:

* The Admin user account (to activate the Logon dialog box).

I accidently cleared the "admin" user account password using the "Clear
Password" button when logged in with a user account in the ADMINS group.

The text above explained why when that happened and I reopened the DB using
the workgroup file it would not open the DB b/c the logon box wasn't
activated b/c the Admin User Account didn't have a password.

I don't think one should be able to clear the Admin User account password
unless logged in as the Admin and not merely a member of the ADMINS group to
avoid these kind of instances.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/community/en-us/default.mspx?mid=39efaec1-f411-4a05-8899-a136fe839ca7&dg=microsoft.public.access.security

4 May 2006 2:02 PM

Joan Wild

I did this once as well. You can restore things by
opening the mdb via your shortcut. Although you'll get no login prompt,
you'll still be using the secure mdw workgroup.
Dismiss the error message.
Go to Tools, Security, Accounts
Click on the Change Password tab and enter a password for the Admin User
(which is the user you're currently logged in as).

One thing you can do is create a user named aa with no password and no
permissions. This user will then appear first in the combobox, so that if
you hit clear password in a hurry, you aren't doing so for the Admin User.

--
Joan Wild
Microsoft Access MVP

Brian wrote:

Show quoteHide quote

> As part of securing a database, it's important to add a password to:
>
> * The Admin user account (to activate the Logon dialog box).
>
> I accidently cleared the "admin" user account password using the
> "Clear Password" button when logged in with a user account in the
> ADMINS group.
>
> The text above explained why when that happened and I reopened the DB
> using the workgroup file it would not open the DB b/c the logon box
> wasn't activated b/c the Admin User Account didn't have a password.
>
> I don't think one should be able to clear the Admin User account
> password unless logged in as the Admin and not merely a member of the
> ADMINS group to avoid these kind of instances.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click
> the "I Agree" button in the message pane. If you do not see the
> button, follow this link to open the suggestion in the Microsoft
> Web-based Newsreader and then click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=39efaec1-f411-4a05-8899-a136fe839ca7&dg=microsoft.public.access.security