Topics Search

disable shift key at startup!

disable shift key at startup!
Views: 258
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:

More topics

 

Disabling the shift key bypass

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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