Require password for Shift key

[Djblois]

When you start Access you can hold down the shift key in order to be able to edit the database. I don't want my users to have access to this. How can I disable this or require a password (preferably with a password so I can still edit it myself.)

 

[HiTechCoach]

I disable the "allow by bypass key" property.

Since you have multiple users, then should be working on a copy of the front end, not he master copy where you make changes.

Once I have all my changes made, I make an MDE and copy thios to the server. I then disable the "allow by bypass key" property.

If I need to get in or make changes, I open the "master".

 

[HiTechCoach]

Here is a great utility for setting the the Allow ByPass:

ByPass Shift Key Utility for Access 2000, 2002, 2003 and 2007
** Note: you do have to log on to get the attachment link

and

Securing AllowBypassKey


There are probably many post here on the subect if you search for Allow ByPass

 

[Djblois]

How else can I disable it without that utility? I have already set it up as a front end and a back end.

 

[HiTechCoach]

How else can I disable it without that utility? I have already set it up as a front end and a back end.

Is the front end shared? It should not be.

Are you wanting to disable the "allow bypass" in the "master" copy of the copy that is deployed?

I also added a second link to my previous post that has other code.

You could use the code for the utility in your own app.

The reason I use the utility to set the "allow Bypass" property with an external Database is that the property does not take effect once set until you exit the database and then get back in.

Note: I would only disable; the "Allow ByPass" property on the deployed copy of the front end.

 

[Djblois]

Thank you I will test this out on Monday when I deploy the program.