Access97 Shift Key

[Guest]

apologies in advance if this appears elsewhere:

I have a secure Access97 database, however, I need to be able to bypass the
SHIFT KEY action in order to prevent users from viewing the main tables.
Is there a SIMPLE way of doing this, or does it involve writing lots of code.
Your suggestions would be most appreciated.

 

[TC]

Check out the AllowBypassKey database property in F1 help. If you
create that property and set it to False, holding down the Shift key
will not bypass the startup properties any more. It's not too hard for
a knowledgable person to turn it back on, though.

HTH,
TC

 

[Guest]

TC - thanks for your prompt reply. I have checked out the 'help' feature, and
am now totally confused. I'm not sure where to create that property? Maybe
I'm reading it wrong. Sorry.

 

[Douglas J. Steele]

Rather than the code from the Help file, grab MichKa's code from
http://www.mvps.org/access/general/gen0040.htm at "The Access Web"

Copy everything into a new module (it's not necessary to save the module,
because you probably won't be using the code again in that database...),
then go the Immediate Window (Ctrl-G) and type:

ChangePropertyDDL "AllowBypassKey", dbBoolean, False

and hit enter.