How To Disable/Enable the Shift Bypass Key in Microsoft Access

Is there any way of preventing user's from holding down Shift Key when opening up my Microsoft Access database and bypassing the Start-Up options which have been disabled. I however, still need some sort of facility to do this, so I can add new forms, queries etc. whenever necessary.

Sponsored Links:

Related Topics

disable shift key at startup!
im developing database in access 2007. I need to bypass / disable the shift key at startup, thus not enabling the user to use the shift key and enable the navigation pane, default menu and access options.
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


Disabling the shift key bypass
I want to disable the shift key so user's can't bypass all my hard work. I found a few posts online about it and have the following code in a module, being called by the AutoExec Macro. but holding down the shift key upon startup still works. Anyone know if its something in the code or if I'm just plain going about this wrong


Can Not Open DataBase. . .
I used a code to prevent the user from pressing the shift key to access the menus on the Database. I placed a textbox in a form that allows me to enter a password that would then enable the shift bypass key.

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?


Start up MS-Access from vb and bypass the autoexec macro
I know that I can startup MS-Access manually and bypass the startup options, including any macro that is set to run automatically, by holding the Shift key down when launching the application. What I need to know is how to do this in a vb program. I have:

Public Sub AccessStuff()
Dim myaccess As New Access.Application
myaccess.OpenCurrentDatabase("\\torfs006\slsops_repts\_\RS Dev\SOP\SOP.MDB")
Dim db = myaccess.CurrentDb()
End Sub

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?


Enable|Disable SHIFT key
Which is placed behind two command buttons on an opening form.
[code]
When I press the cmdDisableSHIFTKey button and close the db and then open it, the db window still appears. I'm using Access 2010.


Access 2010: How to keep Nav Pane hidden
people,
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


Shift key not opening file
I have a database that has been split in to a front and back end. I have the front end set up so to work on it I hold the shift key to open it. All of a sudden holding the shift key does nothing and I get to the user window only.

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.


MDE vs MDB
I have a frontend and a backend database
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?


Cannot edit database in Access 7.0
I purchased a database from another organization to use at work in 2008. I was able to work out some of the bugs that needed to be changed. It was protected from editing, but if I held down the shift key when opening the database it would allow me to open it and edit. My office upgraded from Microsoft Access 2003 to Microsoft Access 7.0. Now, when I hold the shift key to make changes to the database, it opens the regular format - not the background. Can anyone help me with the 7.0 version


How to create a User Login Form in Microsoft Access
In my Microsoft Access database I have a table of Users, each with a user name and password, and a login form set up. I want the user name and password entered into the login form to be compared against those stored in the Microsoft Access table. If a match is found the user is allowed to access to the system, if not the system should exit.
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.


Disabling shift for design view
In MS Access, you can hold down the shift key to open in design view. I would like to disable that ability. I know it's possible, but can't recall how to do it. Could anyone tell me, please


Bypass startup to allow design
I have an ADP file that I would like to work on the design of but when I try to open it it goes into the locked down menu and switchboard. In the past with MDB's I could hold down SHIFT to bypass this but this doesn't seem to be the case with this datbase so I assume the original designer coded it to not allow the bypass.

So my question is, how do I get into it to edit it then? I'm guessing there is some sneaky way that I'm just not privy to


Should I worry about disabling the shift key?
I've read up on the following issue, but if there are any experienced Access users out there, I'm really interested to hear opinions on the subject.

I'm about to make my database available to users. Everything is locked down pretty well. The only thing I'm concerned about is the fact that anyone wishing to get into the database can simply hold the shift key down when opening the database.

I've read that there is a way to disable this option but it doesn't look that straight forward. Is it possible to build this code into a database so that it runs the disable option the first time a user logs in?

I have downloaded a database I found online with code I assume I could potentially adapt, ("AllowBypassKey2k"),

Should I worry about this threat or is it not worth it?

Thanks for any advice you have on the situation.


Disable the Shift key when logging into a secure database
In Access 2003/XP/2000/97, I've secured a database using the User-Level Security Wizard and I've also hidden the Database window in the Startup Options for the database. However, when a user logs in while holding down the Shift key, the Startup Options are bypassed and the Database window appears.


Re-enable the Shift key when logging into a secure database
In Access 2003/XP/2000/97, I've secured a database using the User-Level Security Wizard and I've also hidden the Database window in the Startup Options for the database. However, when a user logs in while holding down the Shift key, the Startup Options are not bypassed and so the Database window will not appear.


Change SHIFT key to something else for re-enable ribbon "allow full menus"
Is there a way to change SHIFT key to something that we want for showing ribbon "allow full menus" back?
example is we have secret combination keys that we choose to re-enable ribbon "allow full menus


Enable or disable macros in Office documents
This article is about macro security and explains the risks of enabling macros and how the Trust Center in the 2007 Microsoft Office system can help to mitigate these risks.
In this article:
* What is a macro and what is the security risk?
* Enable or disable macros with the Trust Center
* How can the Trust Center help protect me from unsafe macros?
* A security warning asks if I want to enable or disable a macro. What should I do?


Change SHIFT key to something else for re-enable ribbon "allow full menus"
Is there a way to change SHIFT key to something that we want for showing ribbon "allow full menus" back?
example is we have secret combination keys that we choose to re-enable ribbon "allow full menus"?


Macro work but Doesn't Work
we have a system to enter data and print data. now to secure the database, I have created an autoexec macro that runs at startup and check if the user is me.
If its is, it will enable the bypass key so that the user (myself) can view the design view of the code else it will disable it.

No here the problem. its works everywhere but recently I had send it to another county to work and now it doesnt work. If its possible that the IT Administrator disabled the MACROs from loading


Shift-Click Not Working Access 2010
For some reason, I cannot get Shift-Click to work in Access 2010.

Originally, I put in a shift-click disable module to prevent tampering with the database, and had a secret button to click to disable the module, so I could still work in the database.

Well, that secret button decided it didn't want to work in 2010, so I opened the file back in 2003, deleted the secret button, and deleted the shift-click disable module.

When I open the database back in 2010, shift-click still won't open the database up. I've confirmed that it works in 2003; I just need it in 2010 now.

The database is attached if anyone has an idea