How to Encrypt Sensitive Data in Microsoft Access

Sometimes in our databases we need to encrypt certain fields, like password fields (see comments for hashed pwd video) or other sensitive data. In Microsoft Access, this is also possible by using various techniques, usually by integrating with some plug ins or third party dll libraries. However, there are not many simple, easy to install solutions, and so in this episode, I'll show you how to use a few simple add-ins that I created to enable field encryption in your database, using a .net helper I wrote that you can call from MS Access. Let's go encrypt some data!] Related Videos: How to disable and enable the Bypass Key on your MS Access app so users cannot bypass Autoexec/Forms https://youtu.be/DHqOZsH5u5o Link and Relink Your Access Front-End App Using vbScript and a Table-Based Approach https://youtu.be/kJIZ-b9idrg How to Use vbScript to Relink Your User's MS Access Application Front-End Automatically https://youtu.be/JhYgRjkAEnA Use vbScript to Deploy your Access Front End, Create Shortcuts, and Check for Updates on User Login https://youtu.be/ar3ijaG7JtQ How to Encrypt and Hash Passwords in MS Access https://youtu.be/2VrFXQd7xDQ How to Encrypt Sensitive Data in Microsoft Access You are watching this video now! How to Kick Users out of Your MS Access Database https://youtu.be/noKLt1mm7D4 How to Get the IP Address in Microsoft Access https://youtu.be/WjqSbgyD6fQ How to Get the Windows Username in MS Access https://youtu.be/u9TRuwdT46U How to Set Basic Startup Options on Your Microsoft Access Database https://youtu.be/M6VxBY9mt_s See how to build the EncryptConnectStrings.exe in my video here: https://youtu.be/ZTgNinXcLyc This video uses concepts and the exe uses code from here. Please read it to understand which encryption we're using and how it is deployed: https://learn.microsoft.com/en-us/dotnet/visual-basic/programming-guide/language-features/strings/walkthrough-encrypting-and-decrypting-strings Join me on Patreon! https://www.patreon.com/mackenziedataengineering Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link Check out some tech (and support my channel!): https://www.amazon.ca/shop/seanmackenziedataengineering Want the code from this video? http://mackenziemackenzie.com/downloads Interested in transforming your career or finding your next gig? https://system.billzone.com/careers.html Want my team to do a project for you? Let's get to it! https://buy.billzone.com/smdeprojects.html Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #msaccess #encryption