I actually have a video on something very similar to this coming out soon because one of my other students, who took my security seminar, asked if it's possible to have users re-input their password every 90 days. So, I'll be doing something like this very soon. However, keep in mind that if you don't properly lock down your database using the techniques that I show in the security seminar, then having the passwords in a table makes your database vulnerable.

Thank you Richard for responding.  I will be taking the encryption,Registration and Security seminar.  I can afford the Encryption, and Registration.  The Security Seminar  Is a lot of money.   I still have my headaches with VBA.  Do you know that writing code in VBA is like "Putting out grass fires" or as one of my comrades in teaching in middle school said "Herding cats".  I spent some time back in the late seventies being on a Delafield Volunteer Fire Department.  Putting out grass fires was real work between the water back pack and using a shovel its was enough to put a person in heat stroke.  I miss helping people when their down on their luck.  Just memories now!

I just made a sample for this where if the password is over 30 days a form pops up telling the user that they must change their password. I ask for their current password, then their new password, and then I ask them to confirm their new password.

I then decided to take it a step further and built a used password table to append the current password so that no user ever uses the same password more than once.

Oh, I disagree with the herding cats analogy. I programmed in many different languages, including Basic, Visual Basic, C, C++, Pascal, Modula 2, Fortran, JavaScript, and a few others I don't even remember. I'd say that Visual Basic is among the more elegant and easy to use, yet still powerful enough to do everything that the average programmer needs to be able to do. Your code is as clean or as messy as you make it, and yes, I've made some messy code in my past. I still look at my database that I've been using for my business for the past 20 years and find pieces of code that I wrote 20 years ago, and I'm like, "What the hell was I thinking?" LOL. But now that I know better, it's easy to clean it up.

Did you remember Sweetest Day?   One year I slept in the garage with my dog.  Its on Saturday October 21, 2023.   He was naughty. She threw the deadbolts.  Different keys.  If nothing else buy your puppies a treat.

Richard:

I am close to crossing the finish line with my software package.  I desperately need the video on changing passwords every 30 days.  I am well aware of the security seminar.  It will be purchased in the month of November 2023. Plus I will be taking the Registration Seminar In December 2023.  So I can protect my software package from thieves.  In conclusion,  I ask you to please move mountains,  Cross the seven seas and put out this TechHelp video as soon as possible.  I can't be the only person out of all your customers that want a way to change passwords with a timer every 30 days.   Uncle Sam requires all employees to change their passwords every 30 days.  Their workstation is programmed to shutdown.  If it not done.  I had 17 different applications that had passwords that needed to be changed.  After a while,  I ran out of passwords.  Then I had to get real creative.  Now they are headache memories from yesterday.  

Nathan

It's on the (very long) list.

Attention Richard:

I will be taking the security seminar soon.  Now,  This is what you promised in a previous posting. " I actually have a video on something very similar to this coming out soon because one of my other students, who took my security seminar, asked if it's possible to have users re-input their password every 90 days. So, I'll be doing something like this very soon. "

Us developers are going to hold you to your promise. Can you also show how to update the table (the VBA code) with the new passwords.

Nathan

I haven't forgotten about it.

Richard

In regard to my last message.  I am changing my strategy.  I need to investigate and write my own code for a subroutine
that automatically forces the user to change their password.  My timeline for this software was supposed to be ready for Christmas on Amazon in December 2023.  Realistically,  I better set my sights on December 2024.  I still have time.  All is not lost.  Putting someone else code in the database. Makes me open to copyright infringement.  Thus a lawsuit.  Further it teaches me nothing.  So don't worry about it.
So,  I did to some degree abandon my original strategy.  So doing it from the school of hard knocks.

I applaud you for wanting to figure out how to do it yourself. This has actually been on my "to do" list for a TechHelp video for quite some time, so I'll still be making a video out of it, but if you get stuck and can't figure it out, feel free to watch. I consider my free TechHelp videos to be tips and techniques that are free for everyone, so I don't mind if you use them in your projects.

Richard Rost:

I want you to know.  That "Computer Learning Zone"  puts the rest to shame.  I am totally happy with the site.  I can't figure
out where the surveys are.  I never receive one in my email box.   I have never filled out one.  Keep up the good work.  As far
as figuring it out myself.  I learned things from the "school of hard knocks----------------Experience"  It been that way since the Doctor patted me on my Glutus Maximus for 70 years.  I learned a bigger lesson.  When a Drill Instructor was screaming in my ear
and told me to get on the ground than had me doing bends and M....F.....ers.  Then grabbed me by the belt and pulling me up and down.  I  had fun playing in the sandbox.  48 boots kicking up sand.  All that for a G.I Bill and college paid for.  I had no student loans.

Thanks for the compliments. I appreciate that. :)

Force Change Password