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

Sponsored Links:

Related Topics

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


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.


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?


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.


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.


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?


Permantely disable Menus
I have a database that has a form front-end. I want to lock down the database so that nobody can access the forms/VBA code attached to it (tables are are in a separate database). I did this by setting startup options so that menus are hiddens, hidden keys etc.

However, I just found out that when you press shift and double-click on the database to open, it opens up the database with menus etc unhidden.

Is there a way to stop full menus being displayed when you press the shift key and double-click?


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.


Permantely disable MS Access Menus
I have a database that has a form front-end. I want to lock down the database so that nobody can access the forms/VBA code attached to it (tables are are in a seperate database). I did this by setting startup options so that menus are hiddens, hidden keys etc. However, I just found out that when you press shift and double-click on the database to open, it opens up the database with menus etc unhidden. Is there a way to stop full menus being displayed when you press the shift key and double-click?


Password protect switchboard startup bypass
I have an access 2010 database all complete with a user friendly switchboard form that open upon clicking an icon. But I don't want any users to press the SHIFT key and enter and alter any design settings. Is there anything I can do so that upon SHIFT [Enter] press, the user encounters a password request to proceed further, and cancel/wrong password to open the switchboard as a normal startup


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


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.


Startup Options
In Access 2007 I have somehow managed to set the startup option such that the app opens with most of the ribbons greyed out. The only option is to close the db and then reopen by holding down the Shift key.

How do I revert to the original starup where it opens up permitting full access to the ribbons?


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


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.


Disable Form Design Mode
Can anyone tell me how to disable Design mode without going all the way to creating a mde or accde database? I'm running Access 2003. I have disabled shift key, Access Special Keys, Allow Full Menus, Allow Default Shortcut Menus. Each one gets me a little closer. I don't want to disable Allow Built-in Toolbars because the users need that to Filter by Form. However, the Design button is on that toolbar and that lets them get into Design Mode. I think if I can get the Design button off the toolbar, I'll be there


Disable Form Design Mode
Can anyone tell me how to disable Design mode without going the way to creating a mde or accde database? I'm running Access 2003. I have disabled shift key, Access Special Keys, Allow Full Menus, Allow Default Shortcut Menus.

Each one gets me a little closer. I don't want to disable Allow Built-in Toolbars because the users need that to Filter by Form. However, the Design button is on that toolbar and that lets them get into Design Mode.

I think if I can get the Design button off the toolbar, I'll be there.


how Disable ctrl + dot(.) in access
How is it possible to Disable ctrl + dot(.) in access?
The below code accepts code of all keys but dont work for dot(.) :
Private Sub Combo3_KeyDown(KeyCode As Integer, Shift As Integer)
If Shift = 2 Then
Select Case KeyCode
Case Asc(".")


Disable ctrl + dot(.) in access
How is it possible to Disable ctrl + dot(.) in access?The below code accepts code of all keys but dont work for dot(.) :Private Sub Combo3_KeyDown(KeyCode As Integer, Shift As Integer)If Shift = 2 Then Select Case KeyCode Case Asc(".") KeyCode = 0 End SelectEnd Sub


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?