Another method is to issue your app as an mde (rather than an mdb) -
from the menu Tools | Database Utilities | Make MDE File... Then
holding the Shift key will have no effect.
BUT Make sure you keep a copy of the MDB to future development!!
I'm not interested in disabling the shift key. All I want to know is how it
was opened. This would allow me execute one of two queried depending on how
the mdb was opened.