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

Published: 08 March 2022
on channel: Sean MacKenzie Data Engineering
10,878
195

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...  

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://system.billzone.com/smdeproje...

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


Watch video How to disable and enable the Bypass Key on your MS Access app so users cannot bypass Autoexec/Forms online without registration, duration hours minute second in high quality. This video was added by user Sean MacKenzie Data Engineering 08 March 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 10,878 once and liked it 195 people.