Topics Search

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

How To Disable/Enable the Shift Bypass Key in Microsoft Access
Views: 742
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:

Similar posts...


disable shift key at startup!

disable shift key at startup! Icon
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

Disabling the shift key bypass Icon
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. . .

Can Not Open DataBase. . . Icon
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

Start up MS-Access from vb and bypass the autoexec macro Icon
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

Enable|Disable SHIFT key Icon
Which is placed behind two command buttons on an opening form.
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

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

Shift key not opening file Icon
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 Icon
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

Cannot edit database in Access 7.0 Icon
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

How to create a User Login Form in Microsoft Access Icon
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.