Hi all~

Is there any way in 2010 to disable the shift key while opening to prevent a savvy user from accessing stuff they shouldn't? I've set the options to disable "special" keys but obviously that's done not a bit of good- is this MS's way of allowing a VERY well known backdoor for developers to get back into the DB?

There are code examples in the Access Archive forum. Search for bypass

Hi Adwatts3537: I am using this code from databasedev.co.UK in MS/Access 2010.

I hope this helps. . .

Tony N.

Here are a few example:

Re-Enabling a Bypassed Shift-Key

ByPass Shift Key Utility for Access 2000, 2002, 2003 and 2007

Tony N and Adwatts3537,

Have you looked through the UtterAcess forum Access Code Archive?

I have found many great example there.

Is there a way to disable SHIFT BYPASS only in ACCDE? That is I want to disable SHIFT bypass when I make ACCDE but not when in ACCDB.

Hi satish



I use this code as part of the start up routine:


The database needs to be opened (to run the code in the start up routine) after the mde/accde is created and before it is distributed.

hth

Edit:
Added reference to CurrentDb

This post has been edited by pere_de_chipstick: Apr 27 2012, 03:32 AM

Sure.

After I make my mde or accde is when I lock it down.

As Bernie (pere_de_chipstick) pointed out is is easy to test to see if the database been compile. I usually set up my front ends so start up routine looks to see if the database is compiled. If it is then it sets all the start up option and disable the bypass. Before deploying I open the front end once to lock it down.

As part of my lock down, I run most of my front ends with Access in runtime mode. This also disables the navigation pane (or database window in older versions) completely. There is also a easy way to test for the mode. If the database is compiled then I test for runtime mode. If not in runtime mode I close the database.