|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
deleting microsoft access user passwordsI need to delete user passwords as the administrator on a access program, and
have followed the "Help" instructions to no avail. On Wed, 12 Jul 2006 10:03:02 -0700, Charge <Cha***@discussions.microsoft.com> wrote:
>I need to delete user passwords as the administrator on a access program, and Log onto Access using the correct Workgroup file and a login with Admin level permissions, then click Tools - Security ->have followed the "Help" instructions to no avail. User and Group Accounts, select the correct user and click the Clear Password button. Note that users can still login, however ... Access accepts a blank password as valid. If you want to disallow users the ability to login, remove the Database Open/Run permissions for those users. Scott McDaniel scott@takemeout_infotrakker.com www.infotrakker.com Thank you, Mr. McDaniel, the problem I had when this was attempted was, the
"Clear Password" button is greyed out, and does not allow access.... We have a program supported by microsoft access. And, now only I can access the program and the users cannot. When they attempt to they are prompted to enter a "Password" which was never setup for them. I was told because I added a "Password" on my "Admin" Account, the secured the program and now requesting users to add a password to gain access. I need to delete my password from the system, which is how we were previously.... Hopefully then the users can log in... Help !! Show quoteHide quote "Scott McDaniel" wrote: > On Wed, 12 Jul 2006 10:03:02 -0700, Charge <Cha***@discussions.microsoft.com> wrote: > > >I need to delete user passwords as the administrator on a access program, and > >have followed the "Help" instructions to no avail. > > Log onto Access using the correct Workgroup file and a login with Admin level permissions, then click Tools - Security - > User and Group Accounts, select the correct user and click the Clear Password button. > > Note that users can still login, however ... Access accepts a blank password as valid. If you want to disallow users the > ability to login, remove the Database Open/Run permissions for those users. > > Scott McDaniel > scott@takemeout_infotrakker.com > www.infotrakker.com > On Thu, 13 Jul 2006 06:45:01 -0700, Charge <Cha***@discussions.microsoft.com> wrote:
>Thank you, Mr. McDaniel, the problem I had when this was attempted was, the Then you didn't login with an account with sufficient rights. You must login to Access using an account that is either>"Clear Password" button is greyed out, and does not allow access.... (a) a member of the Admins group or (b) has sufficient rights to alter this (i.e. mimics the permissions of the Admins group). We have >a program supported by microsoft access. And, now only I can access the Same applies as previous - you must use a login with sufficient permissions to do this.>program and the users cannot. When they attempt to they are prompted to enter >a "Password" which was never setup for them. I was told because I added a >"Password" on my "Admin" Account, the secured the program and now requesting >users to add a password to gain access. I need to delete my password from the >system, which is how we were previously.... Hopefully then the users can log >in... Help !! Access User Level Security is always turned on (even out of the box on a new install). All users login as Admin, and the Admin has a blank password. Your info is correct - adding a password to the Admin user causes everyone to have to login. Did you create a new workgroup file when you were playing around with security? Are you joined to that file (you can check this by opening Access and clicking Tools - Security - Workgorup Administrator)? If you are, try to Join the system.mdw file ... this may solve your problems. Users will all have a blank password ... you can remove security, but the easiest way (assuming you used the Wizard) is to use the backup created by the wizard ... should be in the same directory as the original file. Show quoteHide quote > Scott McDaniel>"Scott McDaniel" wrote: > >> On Wed, 12 Jul 2006 10:03:02 -0700, Charge <Cha***@discussions.microsoft.com> wrote: >> >> >I need to delete user passwords as the administrator on a access program, and >> >have followed the "Help" instructions to no avail. >> >> Log onto Access using the correct Workgroup file and a login with Admin level permissions, then click Tools - Security - >> User and Group Accounts, select the correct user and click the Clear Password button. >> >> Note that users can still login, however ... Access accepts a blank password as valid. If you want to disallow users the >> ability to login, remove the Database Open/Run permissions for those users. >> >> Scott McDaniel >> scott@takemeout_infotrakker.com >> www.infotrakker.com >> scott@takemeout_infotrakker.com www.infotrakker.com 
Other interesting topics
Adv/disadv of using Access built-in security tools vs build in db
Network Security multiple users, Getting rid of the warning messag corrupt files Installed updates, now macros don't work! Creating security for MS Access application log in problems Startup problem with runtime and no-runtime apps Unable to merge after sharing database Missing User data on some macros stops conversion of Access97 to Access2003 logon |
|||||||||||||||||||||||
