Hiding database window

[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

 

[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