• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

10. Multiuser Applications > 10.7. List All Users with Blank Passwords

10.7. List All Users with Blank Passwords

Problem

As database administrator, you need to ensure that every member of your workgroup has an Access password. You can use the NewPassword method to create a new password, and you understand why you can’t retrieve the value of a user’s password, but you need a way to find out whether a user has established a password yet. You’d like to create a list of all users, indicating which ones don’t have passwords. How can you do this?

Solution

You can’t retrieve users’ passwords, but there’s an easy way to find out if a user has a blank password: simply try to log onto the user’s account using a blank password. If you succeed, you know the user has no password. With a lot of users this becomes a tiresome process, but fortunately, you can automate it using DAO and the CreateWorkspace method.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint