Home All Groups Group Topic Archive Search About

Open database while holding down shift key

Author
17 Oct 2007 7:22 PM
bikemrh
I used the security wizard on my access database, and turned off shortcut
keys so the users cannot change code, forms, queries, etc. One of my smarter
staff found out that if you hold down the shift key when opening the
application it bypass the switchboard and opens to the database selection
window. How can I prevent this?

Author
17 Oct 2007 7:38 PM
Joan Wild
See
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm

--
Joan Wild
Microsoft Access MVP
Show quote
"bikemrh" <bike***@discussions.microsoft.com> wrote in message news:5C20E52E-E810-41A3-80B1-5E658388593D@microsoft.com...
>I used the security wizard on my access database, and turned off shortcut
> keys so the users cannot change code, forms, queries, etc. One of my smarter
> staff found out that if you hold down the shift key when opening the
> application it bypass the switchboard and opens to the database selection
> window. How can I prevent this?
Author
17 Oct 2007 7:51 PM
bikemrh
OK, I should have stated that I am sort of new. That is complecated code.
Where would I place the code and what woudl I have to change?

Show quote
"Joan Wild" wrote:

> See
http://www.mvps.org/access/modules/mdl0011.htm
> and
http://www.mvps.org/access/general/gen0040.htm
>
> --
> Joan Wild
> Microsoft Access MVP
> "bikemrh" <bike***@discussions.microsoft.com> wrote in message news:5C20E52E-E810-41A3-80B1-5E658388593D@microsoft.com...
> >I used the security wizard on my access database, and turned off shortcut
> > keys so the users cannot change code, forms, queries, etc. One of my smarter
> > staff found out that if you hold down the shift key when opening the
> > application it bypass the switchboard and opens to the database selection
> > window. How can I prevent this?
>
Author
17 Oct 2007 9:03 PM
Joan Wild
You may find it easier to use the utility at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
Look for 'By Pass Shift Key Code' on that page.


--
Joan Wild
Microsoft Access MVP
Show quote
"bikemrh" <bike***@discussions.microsoft.com> wrote in message news:3B563883-66FD-4A45-9643-753FCF2A23C2@microsoft.com...
> OK, I should have stated that I am sort of new. That is complecated code.
> Where would I place the code and what woudl I have to change?
>
> "Joan Wild" wrote:
>
>> See
>>  http://www.mvps.org/access/modules/mdl0011.htm
>> and
>>  http://www.mvps.org/access/general/gen0040.htm
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>> "bikemrh" <bike***@discussions.microsoft.com> wrote in message news:5C20E52E-E810-41A3-80B1-5E658388593D@microsoft.com...
>> >I used the security wizard on my access database, and turned off shortcut
>> > keys so the users cannot change code, forms, queries, etc. One of my smarter
>> > staff found out that if you hold down the shift key when opening the
>> > application it bypass the switchboard and opens to the database selection
>> > window. How can I prevent this?
>>
Author
18 Oct 2007 12:17 PM
bikemrh
Worked like a charm. thank you!

Show quote
"Joan Wild" wrote:

> You may find it easier to use the utility at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
> Look for 'By Pass Shift Key Code' on that page.
>
>
> --
> Joan Wild
> Microsoft Access MVP
> "bikemrh" <bike***@discussions.microsoft.com> wrote in message news:3B563883-66FD-4A45-9643-753FCF2A23C2@microsoft.com...
> > OK, I should have stated that I am sort of new. That is complecated code.
> > Where would I place the code and what woudl I have to change?
> >
> > "Joan Wild" wrote:
> >
> >> See
> >>  http://www.mvps.org/access/modules/mdl0011.htm
> >> and
> >>  http://www.mvps.org/access/general/gen0040.htm
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >> "bikemrh" <bike***@discussions.microsoft.com> wrote in message news:5C20E52E-E810-41A3-80B1-5E658388593D@microsoft.com...
> >> >I used the security wizard on my access database, and turned off shortcut
> >> > keys so the users cannot change code, forms, queries, etc. One of my smarter
> >> > staff found out that if you hold down the shift key when opening the
> >> > application it bypass the switchboard and opens to the database selection
> >> > window. How can I prevent this?
> >>
>

AddThis Social Bookmark Button