Building on an old post MS Access VBA – Generate a Random String, I wanted to post a fully functional sample in which I added full support for multiple string generation. I use this tool to generate a set of random passwords and then pick one to create a new account password…
The beauty of this tool over many others, is that you run it locally, not on someone else’s server (god knows if your actions are being logged with malicious intent) like all the online generators do (yes, call me paranoid – in today’s world one cannot be too safe). This way, you remain in control.
The other advantage is that the passwords are saved to a Table so you can continue to work with them easily. One word of caution however is that the table gets wiped clear every time you run the generator so be sure to output any result you wish to keep long term to another table or source (Excel, Word, …).
