Allowing or disallowing database window

[Adam]

I am creating a database, and I will normally want to hide the database
window from the user and make interact only through the forms I have
designed. I can do this easily enough by setting the "StartupShowDBWindow"
to false. I can even prevent users displaying the database window by
pressing F11 if I set the "AllowSpecialKeys" property to false.

However, I would like a user with sufficient privileges (defined through
Access user level security) to be able to view the database window. Is it
possible to disallow tricks like F11 for some users, while making them
possible for others? If so, how? If not, how else could I make the database
window available to some users but not others?

Many thanks

 

[Joan Wild]

I assume you have some sort of main form that pops up on opening? You can
add a button that will display the database window
DoCmd.SelectObject acTable, "SomeTable", True

In the open event for your form, check whether the currentuser is a member
of the required group and make the button visible or not. There is a
function in the security FAQ you can use to determine if a user is a member
of a group.

http://support.microsoft.com/?id=207793

 

[Adam]

Many thanks, Joan, that's exactly what I need.

Adam