Check for a password.

[Robert Gunn]

I'm building a small database application with user and group level security.
I've built a few of these before and always wondered if there was a way to
check if the user's login password has been set or not. All I need is to be
sure that the password has been set and that it's not null/empty. I know
that an ADO password can be checked for a null value but can't find a way to
check in Access. Is there a way, Or is this effort futile?

 

[Tom Wickerath]

Hi Robert,

Alison Balter covers advanced security techniques in her book, "Mastering
Microsoft Access 2000 Development", in chapter 34:

http://www.amazon.com/Alison-Balters-Mastering-Microsoft-Development/dp/0672314843

I suspect that she also covers it in a later version, for Access 2002 or
2003. She includes examples of checking for users with no passwords, and code
for how to force a user to enter a password. It looks like you can purchase a
used copy fairly cheap.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________