How to disable and enable the Bypass Key on your MS Access app so users cannot bypass Autoexec/Forms

Access applications can have lots of great startup options like a startup form or Autoexec macros that do things as soon as the application is started. However, these options can easily be defeated by holding down the shift key as the file is opened, exposing all of the design to the user. In many cases, this is really not preferable, since it is better to keep these things hidden from the user. In this episode, we'll look at how to disable the AllowBypassKey property on the database, so that users cannot bypass startup forms and macros. We will also look at one useful strategy for "unlocking" the file so that you can continue to work on it before deploying it to users again.

Related Videos:
How to disable and enable the Bypass Key on your MS Access app so users cannot bypass Autoexec/Forms
You are watching this video now!
Link and Relink Your Access Front-End App Using vbScript and a Table-Based Approach
   • Link and Relink Your Access Front-End...  
How to Use vbScript to Relink Your User's MS Access Application Front-End Automatically
   • How to Use vbScript to Relink Your Us...  
Use vbScript to Deploy your Access Front End, Create Shortcuts, and Check for Updates on User Login
   • Use vbScript to Deploy your Access Fr...  
How to Encrypt and Hash Passwords in MS Access
   • How to Encrypt and Hash Passwords in ...  
How to Encrypt Sensitive Data in Microsoft Access
   • How to Encrypt Sensitive Data in Micr...  
How to Kick Users out of Your MS Access Database
   • How to Kick Users out of Your MS Acce...  
How to Get the IP Address in Microsoft Access
   • How to Get the IP Address in Microsof...  
How to Get the Windows Username in MS Access
   • How to Get the Windows Username in MS...  
How to Set Basic Startup Options on Your Microsoft Access Database
   • How to Set Basic Startup Options on Y...  

For developers looking for a new role, check out and sign up:
https://www.toptal.com/qKaO2b/worlds-...

Needing to hire technical resources for your project? Get the best:
https://www.toptal.com/qKaO2b/worlds-...

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

  / mackenziedataengineering  

Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-...



Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
  / mackenziedataanalytics  
  / seamacke  
  / seamacke  
  / seamacke  
  / psmackenzie  

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...


#msaccess #access #vba