Forgotten Passwords

[SSgt Herrera]

I have been assigned to maintain a database that have a
lot of users that have forgotten their passwords to get
into it. How could I change those passwords? Thank you.

 

[Scott McDaniel]

You'll need to logon to the db as a user who is a member of the Admins
group. From there, you can clear those users passwords by accessing the
Tools - Security - User and Group Accounts dialog and (a) select the User
and (b) click the "Clear Password" button. Your users can then log on to the
database and access the same dialog except they'll click the Change Password
tab (or you can log off of your current username and log BACK on using the
UserName of the person you just cleared and set their password for them ...)
--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

"Smash forehead on keyboard to continue ... "