The problem is that the shift key mechanisms of course has already occurred
when you entered the database....
Of course, during development, you will hold down the shift key so your
startup settings don't run. You then develop for awhile, and then to test in
"user" mode, you exit..and then re-enter the application without the shift
key bypassed. You will likely do this dance all day long as you run/test as
user mode, and then flip back in to developer mode (shift key used..so you
don't get the main custom menu). So, you can't develop, or really modify
things when you run your application with the startup settings...so you must
shift-by-pass them when you want to work.
And, in fact, I use alt-f4 to exit the application...the mdb file should
still be highlighted in the windows explore..so, then you hit enter key
(and, hold down shift key if you need be). This key stroke sequence and
exiting and re-entering the application will occur CONSTANTLY all day long
when you are developing. clickey clack...this happens in a flash..and the
keys storkres are long hard wirred into my brain as this is done so
much..and is totally instanice.
When you finally have things just right...you create the mde
you plan to distribute...
After you create this mde...you can then use my shfit key code here to
BROWSE to that mde file..and set/unset the shift key code....
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
Also, using a check box might not really make sense..since the database
already will remember this setting.. you could just make two buttons
somewhere
buttion1 = shfit key enabled
buttion2 = shift key disabled...
Of course, these two buttons would have to be restricted from the
users......
As for hiding the interface, well, actualy you don't really need any
secirty.....
You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.
Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.
Check out:
http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm
If you convert the above sample to a mde...and disable the shift key....try
then getting into the application....you will find you can't...
