disable loading with shift key depressed

[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.

 

[Granny Spitz via AccessMonster.com]

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.

 

[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.

 

[Keith Wilby]

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.