Disable Shift Key in Access 2007?

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

 

[Alan Cossey]

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,
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

 

[Alan Cossey]

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


:

<content omitted>

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

Alan