Home All Groups Group Topic Archive Search About

Hiding database window

Author
27 Jul 2006 11:13 PM
jeq214
I've set up user level security by allowing users to only read. I know if you
hold down the shift key while opening a database, it will display the
database window. Is there a way to disable that and any other way to display
the database window? I would like to totally hide the design and database
window from everyone except me. Is that possible?

Jon

Author
28 Jul 2006 3:37 AM
tina
you can set the database's AllowBypass property to False, to disable the
"shift key bypass" action. for more information, see
http://www.mvps.org/access/general/gen0040.htm

*warning*:  make sure you try this out on a COPY of your database, so if you
have problems with it, you don't lock yourself out.
also, suggest you bookmark the mvps.org website, as well as bookmarking
http://home.bendbroadband.com/conradsystems/accessjunkie.html
the two sites are two of the best Access references on the internet, and
you'll find them very useful.

hth


Show quoteHide quote
"jeq214" <jeq***@discussions.microsoft.com> wrote in message
news:807A20FD-87CB-4B98-A516-BD0C86D1AE24@microsoft.com...
> I've set up user level security by allowing users to only read. I know if
you
> hold down the shift key while opening a database, it will display the
> database window. Is there a way to disable that and any other way to
display
> the database window? I would like to totally hide the design and database
> window from everyone except me. Is that possible?
>
> Jon