Shift key bypass not working

[sharontodd]

I've got the DB ready and am trying to implement security measures. I've set
the startup options and want to disallow Shift to be pressed on startup. I
tried the utility posted several times by Albert D. Kallal but I get an error
message "Object variable or with variable not set" when I run it and click
disable by pass key.

Any thoughts or another way to achieve this?

THANKS !!!!
Sharontodd

 

[ErezM via AccessMonster.com]

hi
what's wrong in creating a property called "AllowBypassKey" and setting it's
value to False?
it works perfectly for me.
and if you're worried about smart hackers that will set this property to True
from outside your application, then check for it's value on the first form to
open (or on the most critical form there is), and DoCmd.Quit if you dont like
the result.
that is all assumming you are leaving only MDEs on the client, not MDBs on
which the code itself can be manipulated. aren't you?

if you need more help, just tell me
good luck
Erez

 

[Keith Wilby]

and if you're worried about smart hackers that will set this property to
True
from outside your application, then check for it's value on the first form
to
open

Anyone can manipulate the AllowBypassKey property unless you set the DDL
flag accordingly so that only an administrator account can change it. Even
then you'd have to have user-level security set up and have a custom admin
account.

To the OP: Albert's utility should work just fine. Do you have full
permissions to the host folder?

Keith.
www.keithwilby.com

 

[sharontodd]

I tried to create a button and placed the following code:

SetProperties "AllowBypassKey", dbBoolean, False

I get a message "Sub or function not defined" for SetProperties.

I tried to make an MDE file but got an error. I checked the list of 16
reasons you may get an error on that but couldn't find a problem. Also, One
of the things I want the user to be able to do is export a report to Excel -
I read you can't export from an MDE file.

This is the first major DB I have developed and I'm learning LOTS of new
stuff. Thanks for your help!

Sharontodd