Disable VBA window in Access Database
Posted on 2011-03-10
I have an access database being deployed to some users. They use full run Access, and I have locked down the Current Database settings such as Nav Bar, Developers Toolbar, etc. I have also added code for the AllowBypasskey Property so they can't use the Shift key.
Everything is perfect. Except.... There is a TON of code in this database. If they hit an error that hasn't been trapped, they get the "End" or "Debug" window, and it takes them to the VBA window with the error highlighted. How can I prevent them from ever getting to this window?