Hi Sam,
You see Admin on the Change Logon Password tab because you are logged on as
the Admin account.
Give the Admin account a password (remember the password). Close Microsoft
Access and then reopen it. You will be prompted for User Name and
Password. Enter the correct User Name and Password.
If you don't remember the User Name and Password log back in as the Admin
account.
Select the menu option Tools > Security > User and Group Accounts
From the drop down select the User account and click Clear Password.
NOTE: in order to be prompted for User Name and Password the Admin account
must have a password. If not, every logs into the database as the Admin
account.
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
| Content-Class: urn:content-classes:message
| From: "Sam" <
[email protected]>
| Sender: "Sam" <
[email protected]>
| Subject: I created a user and I can't log on as that user
| Date: Wed, 7 Apr 2004 08:09:14 -0700
| Lines: 20
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQcskocrvIhoPnzSgOCrmupOWWZEA==
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:9767
| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| X-Tomcat-NG: microsoft.public.access.security
|
| Hello,
|
| I followed the instructions exactly on how to create a
| security administrator account (following Access 97
| help). For some reason, I can't seem to log in as that
| user even after I have created a unique password.
|
| The Access Security FAQ's page suggests that I should type
| in the user name in the opening dialog box without the
| password. That didn't work.
|
| One strange thing I find, after I have created the user
| name, when I click on the "Change Logon Password" tab, the
| user name says "admin". If I click back on the "Users"
| tab, the name I have as the new account is highlighted.
| Is there a problem here?
|
| A response would be much appreciated.
|
| Sam
|
