Microsoft Access Disabling the Shift-Key

Disable the AllowBypassKey Property
Sometimes we, as developers, want certain code to execute at application startup. Holding the shift-key during application startup will prevent all code from running, macros and VBA. Microsoft provides a hidden database property that allows us to prevent the shift-key from preventing our startup code from running. They do not provide a way to set this value from the Access user interface, you can only set this value using VBA.
In this video we will:
1. Interrogate the value of the AllowBypassKey property
2. If the AllowBypassKey does not exist, we will create it
3. We will also set the value of the AllowBypassKey property
The VBA in this video can be found here:
accessjitsu.com...
All of my videos organized by topic and other blog topics:
accessjitsu.com/

[@excelclassdaniel178]

Super helpful!! Works great! I've been wondering how to prevent others from using that loophole for a while.

[@sudhanhari9799]

Thanks for a good explanation with a proper illustration.

[@ahmediraqihot]

Thank you so much Explanation was excellent Wait for you more New explanations We wish you success in your business

[@garycurtis]

Great video thank you. Question, do you need to even do this if you are using Ms Access runtime?

[@thamonito]

Wow, it actually works. Thank you so much man! You're awesome!

[@chauhanrkarya]

Thanks Sir, I really appreciate your work. Thanks again Sir!

[@pajudi2210]

Valeu amigo! Muito bom! Não conheço muito bem VBA. Tem algum exemplo para baixar?

[@drPJJohnson]

Wow...This is really helpful. Thanks for sharing.

[@tmusuza4744]

Hi Jitsu, I'ved loved this video. You are super. This was the missing link to my Access security. Now i can prevent all the nosing Just 2 questions, After setting the bypass to False, How often do i have to do this? And After I've created my accde, will hackers still be able to nose in Thank you and Appreciation from Uganda :)

[@iliesboukhatem7803]

I think that you need to enable it one ;)

[@xm_tech]

The link to the VBA is not working.

[@dennisangelramosarias4637]

PLEASE , CAN YOU SHARE ME THIS ARCHIVE , PLS?

[@user-gp2qk6lx7v]

Hello My dear as possible send me on this amyl how or designed Shafat system program Accesse 2007 of two buttons , a Cancel button enable Shafat button because I do not know that I work Shafat program Accesse though you have more syllables Fargo to send me all Praise Allah reward you note I'm from Iraq