Ms Acces 2003 Password control

[tamilvendhan]

Hi all,

Here in our office, we us a common database created using MS Access 2003. So every user has a login. Most of the users has a blank password. I want to make it mandatory to have non-blank password . can anyone have idea how to do that. ?

 

[burrina]

Not sure how you things setup, but all users should have passwords.
You should gave a username and password for each user.
Example:

If IsNull(Forms!frmpasswordadmin!Text0) Then               'No Blank passwords allowed
    MsgBox "You cannot enter a blank Password. Try again."
    Me!Text0.SetFocus
Else

 

[tamilvendhan]

Thanks burina,

But I use the default login screen of access, with which we cant write a code

Also i use the Access default change logon password screen to set passwords

 

[burrina]

Sorry, I don't use that in any of my db's. Still, you can set a password for each user using this process to my knowledge.