I'd set up a table of Security Questions. When the user creates their account (User Record) have them choose a question to be asked for password retrieval and type in their answer.

Have a link on the Log In form and ask the user for their Username, Email Address and the answer to their Security Question.
This can be done with a Form or a series of Input Boxes (I prefer a Form for this).
If ALL 3 match you can send the user their password, either by Email or in a well designed Form.

Hey Kevin, thanks for sending me that suggestion on how i could possibly do it. First I need to find out if all the volunteers would like that. I only got 2 people that asked me about theirs since we started. Nice feature to have but is everyone on board. Thanks again.

Use https://keepass.info/

You could always set up 2FA (two-factor authentication) and make a link to have the user's password sent to their phone via text message. Text Messages

Hey Richard, I saw your video about the text messages. Now I need to ask everyone if they would like to use just text messages or keep it the way it is for now. I also checked the referral link also, but it doesn't work. It says page not found. Sorry.

You could also just use email too, but you couldn't use Outlook email because the user could then just intercept the email from the outbox. You'd have to send direct to the mail server, like I show in the Access Email Seminar.

And yeah, looks like that referral link is dead. Those bastards. LOL. It's OK. I don't think I ever saw any commission from them.

I usually send log in credentials with Docmd.SendObject:

    DoCmd.SendObject acSendNoObject, , acFormatTXT, Email, , , Subject, Body, False

Right, but if you do SendObject, that's going to push it to the local Outlook Outbox on the PC. ANY user could then open Outlook and see what the password is for ANY user. For it to be secure, you'd need to send using the API direct to the SMTP server.

Personally, I think security questions are the easiest - but don't make your question something like "what's your favorite band?" and everyone in the office knows you're a huge Rush fan. LOL

I did ask some people at my workplace, little by little it's getting there. I'll be using the text message. Thanks again.