Using "Use Access special Key"

[David M]

I want to prevent people pressing F11 to see the tables / queries in a
database- deselecting "Use Access special key" in the startup section in
Tools- it appears to do it- but how can I reactiviate the back end for
changes I might want to do- e.g is there a macro code I could run?

Many thanks

David

 

[Peter YangMSFT]]

Hello David,

You might be able to change the startup option such as "Use Access special
key" by code, but it takes effect only after next start of the database.

Usually you shall use CreateProperty function to change AllowSpecailKeys
property. You may want to search CreateProperty in VBA window help link.
Also, please see the following links for more related information:


210169 ACC2000: How to Use Visual Basic to Change the Application Title
http://support.microsoft.com/default.aspx?scid=kb;EN-US;210169


http://www.mvps.org/access/general/gen0040.htm

If you have any further questions or concerns, please feel free to let's
know. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[tina]

when *you* want access to the database window, just hold down the Shift key
while opening the database - that bypasses the Startup settings. keep in
mind that it will be just as easy for your users to find out as it was for
you.

you might want to look into disabling the AllowBypass setting, to prevent
your users getting into the db at will. for more information, see
http://www.mvps.org/access/general/gen0040.htm.

hth

 

[Jeff Boyce]

David

The suggestions you've received so far involve keeping the file you
distribute to your uses as an .MDB file. If you make an .MDE file out of
it, the users won't be able to change your design (but can still see it, if
I recall).

Maybe you need to replace your users?<g>

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[tina]

though David did specifically say he wants to keep the users away from
tables and queries, Jeff, and of course an .MDE file will not protect those
objects at all. (i have frequently thought that your "replace users" option
would be a great solution in many situations! <g>)