How To Disable/Enable the Shift Bypass Key in Microsoft Access
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have gone through all the forum, searched a lot, tried AllowBypassKey2kTo2k7 solution, but im not able to get the result.
the solution given by ghudson in this forum shows no message box after password input, whether you input it correct or wrong.
the solution given by MadMaxx in this forum shows error number
Due to some error I don't understand, the form opens up blank with no visible textboxes. I know there is a way around this by opening an alternate database. Can anyone please advice?
Public Sub AccessStuff()
Dim myaccess As New Access.Application
Dim db = myaccess.CurrentDb()
which works nicely and opens the database just fine. However, this mdb has a startup macro defined in it. I can't hold down the Shift key since I'm doing this from a program. In thiscase, how can I bypass the startup macro?
When I press the cmdDisableSHIFTKey button and close the db and then open it, the db window still appears. I'm using Access 2010.
Q. In Access 2010, how do you stop a hidden Navigation Pane from being unhidden?
These things I know:
- In MS Access you can hide the Navigation Pane to prevent users from getting to the form objects etc.
- This setting can be bypassed by holding SHIFT while opening the database.
- There is code that can disable the bypass key (the SHIFT key).
In MS Access 2007 this works fine. You can't get to the Options to turn the Nav Pane back on.
But now comes my problem: In Access 2010, the File menu is still visible, which has the 'Privacy Options' available. This lets the user go in and switch the Nav Pane back on again.
How do I stop this in Access 2010? I either need to remove the File menu, or remove the Privacy Options item from it
I have tested this on another computer and the database works correctly there - opens to working area with the shift key. AND I have tested another database on this system and it ignores the shift key.
Does anyone have any idea how I could have disabled the shift key for one system only? I have to deliver this version to the client in the morning.
both backend (BE) and Frontend (FE) are MDB
I have hide all tables in BE and FE and in menu tools > startup I have almost unticked everything so people cant'se F11 to go to the main database but if people startup the database and holding the Shift key, then they see the main database but everything is hidden, to see the hidden tables they need to go menu tools > options and tick "show hidden tables" and I found a way to disable the shift key during startup (I think bypass shift key or something) but I'm not doing that. and I have a MDW file, so people don't need to put they're username and password but they can't go to any design view because of the MDW.
I have compiled the mdb to mde but I dont see a big difference.
is creating a mde interesting for me? what are the benefits of this?
Answer » The following details one procedure that could be applied to this scenario. There are many more approaches to this and also other areas that will need to be secured within your database environment. You should also look into Disabling/Enabling the Shift Bypass Key.