You are here:

Using MS Access/force user to change pwd at first login


Dear sir,

I have a db with employee ID, surname and password.when they login to the system via a login form it all works well, but I want the user to change their pwd at the first login into the system. Can you help me, thanks in advance.

What kind of security are you using? If you're using old-style Access 2003 (and before) user-level security, then I'm afraid I can't help you. Microsoft discontinued that with Access 2007 so I haven't worked with it for YEARS. I show my students how to set up their own database security in my ACCESS SECURITY SEMINAR.

Now, checking for the first logon is not hard at all. Just have a y/n field for HasLoggedOnBefore in your employee table, and DLOOKUP the value when they log in. If it's set to NO then launch whatever process you have to to force them to enter their password which, sadly, I don't know how to do. (Did I mention it's been a while). I'm sure if it's possible you should be able to Google some code for it.

Sorry I couldn't be of much more help.

Be sure to visit my web site and watch my FREE 90-minute Microsoft Excel Video Tutorial

Richard Rost
599CD Computer Training

Using MS Access

All Answers

Answers by Expert:

Ask Experts


Richard Rost


I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site, and free Access 101 tutorial.


I am the president of and I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at

©2017 All rights reserved.

[an error occurred while processing this directive]