Disable Shift Open Feature

[JR_06062005]

There is a feature in Access which allows one to open a database and by pass
all modules, all macros and the startup options. All one has to do is hold
down the shift key when opening the database. Is there a way to disable this
feature?

 

[Douglas J. Steele]

Create a database property named AllowBypassKey and set its value to False.

See http://www.mvps.org/access/general/gen0040.htm at "The Access Web" for
how to do this properly.

 

[Shanin]

I have tried this but always get a compile error on the first function,
saying not defined. I tried the work around in another post about error
handling on 3265 instead and I still get the same compile error?

 

[Douglas J. Steele]

Assuming you copied everything between Code Start and Code End and pasted it
into a new module (not a class module, nor a module associated with either a
form or report), what did you name the module? Modules cannot have the same
name as routines contained within them.

 

[Shanin]

I figured out my own idioticy. I forgot to mark the reference for DAO 3.6.