Home All Groups Group Topic Archive Search About

disable loading with shift key depressed

Author
16 Nov 2006 4:58 PM
MES via AccessMonster.com
I have an access database that I am working on that will be placed on our
organization's intranet that employees will be able to use.  It is pretty
well protected - the last thing I think I need if possible is how to disable
the capability of loading it with the shift key depressed - this opens up the
whole structure to tampering.  Is there any way to disable this?

Thanks in advance for your help.


Author
16 Nov 2006 5:16 PM
Granny Spitz via AccessMonster.com
MES wrote:
> the last thing I think I need if possible is how to disable
> the capability of loading it with the shift key depressed - this opens up the
> whole structure to tampering.  Is there any way to disable this?

Apply User level security, then sign in as a member of the Admins group and
use the code here: http://www.mvps.org/access/general/gen0040.htm.

--
Message posted via http://www.accessmonster.com
Author
16 Nov 2006 5:30 PM
Lynn Trapp
Just to add a warning to Granny's good suggestion. Keep a copy of the
database for yourself which still has the shift key bypass enabled and/or be
prepared to run the procedure again and re-enable it, if you need to make
changes.

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com


"Granny Spitz via AccessMonster.com" <u26473@uwe> wrote in message
news:6961d3272e8ee@uwe...
Show quoteHide quote
> MES wrote:
>> the last thing I think I need if possible is how to disable
>> the capability of loading it with the shift key depressed - this opens up
>> the
>> whole structure to tampering.  Is there any way to disable this?
>
> Apply User level security, then sign in as a member of the Admins group
> and
> use the code here: http://www.mvps.org/access/general/gen0040.htm.
>
> --
> Message posted via http://www.accessmonster.com
>
Author
17 Nov 2006 8:38 AM
Keith Wilby
"Lynn Trapp" <ltrappNoSpam@ltcomputerdesigns.com> wrote in message
news:%23w3K3TaCHHA.856@TK2MSFTNGP02.phx.gbl...
> Just to add a warning to Granny's good suggestion. Keep a copy of the
> database for yourself which still has the shift key bypass enabled and/or
> be prepared to run the procedure again and re-enable it, if you need to
> make changes.
>

Better yet, you could use the excellent utility developed by Albert D.
Kallal.  Search for "By Pass Shift Key Code" here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Regards,
Keith.