Home All Groups Group Topic Archive Search About

Disable Shift Key in Access 2007?

Author
21 Dec 2006 11:46 PM
Jason Brady
Hello,

How do I disable the shift key in Access 2007?  I am building a front-end
database to be deployed as an ACCDE and want to prevent the users from
viewing the underlying components.  I understand how to accomplish this in
previous versions of Access but am unable to find any reference to the
AllowBypassKey property, or shift key disabling, etc., in the version 2007
documentation. 

Might be missing something obvious, so any help is appreciated.

Thank you.

--
Jason Brady
Brady Systems Solutions, LLC
Lynnwood, WA USA

Author
23 Dec 2006 1:54 PM
Alan Cossey
Show quote Hide quote
"Jason Brady" <JasonBr***@discussions.microsoft.com> wrote in message
news:CBA11859-6BC3-4067-A550-89A39CF3E2F3@microsoft.com...
> Hello,
>
> How do I disable the shift key in Access 2007?  I am building a
> front-end
> database to be deployed as an ACCDE and want to prevent the users
> from
> viewing the underlying components.  I understand how to accomplish
> this in
> previous versions of Access but am unable to find any reference to
> the
> AllowBypassKey property, or shift key disabling, etc., in the
> version 2007
> documentation.
>
> Might be missing something obvious, so any help is appreciated.
>
> Thank you.
>
> --
> Jason Brady
> Brady Systems Solutions, LLC
> Lynnwood, WA USA

Jason,
You do it the same way as before. However, with accdb/e, you cannot
stop people from reversing what you have done since workgroup security
does not apply with accdb/e files.
The only way we could come up with to do this in a discussion at
UtterAccess.com was along the lines of that described in the PDF file
at http://www.pdtltd.co.uk/pdtl/technicalresources.htm.

Alan Cossey


--
Posted via a free Usenet account from http://www.teranews.com
Author
27 Dec 2006 5:57 PM
Jason Brady
Alan,

Thanks for the information.  I tried to use the disable technique from
Access 2003 but it did not work (add AllowBypassKey property to the Database
collection, set value to False).  No error message was displayed, either.  At
least the back-end database is password-protected.  Still, it is suspicious
that Microsoft makes no reference to the property nor specific mention of a
method for disabling the bypass key, unlike the 2003 documentation.  Work in
progess?

Regards,
Jason


"Alan Cossey" wrote:

<content omitted>
Author
28 Dec 2006 9:47 AM
Alan Cossey
Show quote Hide quote
"Jason Brady" <JasonBr***@discussions.microsoft.com> wrote in message
news:D3B0F03F-F4E2-4990-8FF9-6259DBDC47AB@microsoft.com...
> Alan,
>
> Thanks for the information.  I tried to use the disable technique
> from
> Access 2003 but it did not work (add AllowBypassKey property to the
> Database
> collection, set value to False).  No error message was displayed,
> either.  At
> least the back-end database is password-protected.  Still, it is
> suspicious
> that Microsoft makes no reference to the property nor specific
> mention of a
> method for disabling the bypass key, unlike the 2003 documentation.
> Work in
> progess?
>
> Regards,
> Jason
>
>
> "Alan Cossey" wrote:
>
> <content omitted>
>

"Work in progress?" Yes, I think we are all feeling our way here.

Alan


--
Posted via a free Usenet account from http://www.teranews.com