Although I don't recommend this method, here's the code to disable using the shift key when opening an mdb. Use it sparengly (if ever) and 'don't' lock yourself out of your own mdb by forgetting the password!!
Access/SQL Server Expert
Windows XP 
Access 2003
Although I don't recommend this method, here's the code to disable using the shift key when opening an mdb. Use it sparengly (if ever) and 'don't' lock yourself out of your own mdb by forgetting the password!!
MS MVP - Access Expert
Windows 7 Access 2010 (version 14.0)
I use the method on every front end that I deploy.
If you always split every databases and the "locked" down front end that is deployed as an MDE/ACCDE, this is a great method to use.
Novice
Windows XP Access 2003
Excellent! Thanks got sharing
Access Developer
Windows XP Access 2003
I would make the front end a mde. I would also use the Shift property setting, but I believe it's setting can easily be changed from another db, like the one attached.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
MS MVP - Access Expert
Windows 7 64bit Access 2010 32bit
Bob,
You are correct that the Shift Bypass property can be set from an external app. I use an app that lock down a MDE/ACCDE.
pass value from one form to another
Pass Value to Form
Pass a value from a form to another
Posting Permissions
Reply With Quote