Hi,
I've made an application in Access 2000 and defined different users with
different rights. I've created a startup window and in Tools > Startup
selected that window to start with. I've deselected the checkbox Display
Database Window.

Now all seems OK: when some user opens the app the startup window appears
and not the database window. BUT when that user hits F11 the database window
appears. How can I prohibit that?

Thanks for help

Henk

In startup, uncheck 'allow special keys' - that'll stop F11 from working.
The next thing you'll find is that users have discovered the shiftkey bypass
that will bypass all the startup setitngs, but you can disable that.  Also:

Create custom menus/toolbars for use throughout your application.
Use the features in Tools, Startup to
        set the startup form
        set your default menu (the custom one you made)
        disable all the checkboxes about allowing built in menus, toolbars,
changes etc.
        hide the db window (ensure the custom menu you create does not
include the Windows, Unhide item)
        Uncheck the allow special keys (this will disable the F11 key, among
others)

If you need to bypass these startup features, you can hold the shift key
down while you open the db.  If you feel that your users may use this to
bypass your settings, you can disable the shift key bypass - there's an
example in help for doing this(look for AllowBypassKey) or at
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm

You can also create a MDE from your database, which will prevent changes to
forms, reports and modules (If you do this, be certain to keep your original
mdb in case you need to make changes).


Show quoteHide quote

How secure is Access 2007
Access 2007 Security
system.mdw
Office 2000 Access 2003 Exclusive Open Rights
Security loophole via Excel!!!
user and group permissions on basis of data
Copy Forms and Tables from Secure DB to other Secure DB
get error message when running a query
workgroup files and 2007
Open File Security Warning