Disable using shift key to bypass startup options

[Sheldon]

Hi,

How can I prevent users from holding down the shift key
while opening up a database in order to bypass the startup
options? I'm using Access 2000 to develop, but some users
have a front-end in Access 2003.

After the shift key is disabled, then how do I bypass the
startup options?

Thanks for your help.

Sheldon...

 

[Douglas J. Steele]

You create a boolean database property named AllowBypassKey, and set its
value to False. Use the code from
http://www.mvps.org/access/general/gen0040.htm at "The Access Web" to ensure
that the property is created properly.

Note that you need to use DAO for that code to work. In Access 2000, that
means you'll need to add a reference to DAO, since Access 2000 uses ADO by
default. With any code module open, select Tools | References from the menu
bar, scroll through the list of available references until you find the one
for Microsoft DAO 3.6 Object Library, and select it. If you're not going to
be using ADO, uncheck the reference to Microsoft ActiveX Data Objects 2.1
Library

Once you've set that property, there's no way to open the database and
bypass the startup code. What you can do, though, is reset the
AllowBypassKey property to True, and then you can hold down the shift key
the next time you start up the database.

 

[Albert D. Kallal]

I have a nice little utility that lets you browse to any access database and
set, or un-set the shift key.

Check it out at:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

 

[Sheldon]

Thank you!